Spliting 

Break up names or addresses in one column over many cells. Splits can be done by spaces, commas, or any other distinguishing character. Splits can be done quickly through a wizard on a group of cells that you select.

Divide one field (column) into 2 or more in Microsoft Access. A wizard guides you through the process of selecting a field (and table) to be split. The values found in the field will be split by a delimiting (dividing) character of your choice. The n......

 Spliting