Splitting a Column in Excel

When uploading an Excel list into your Fugent address book,

each piece of data must have it’s own column.

Insert an empty column(s)* next to the column to be split.

Highlight the column to be split and select

Text to Columns from the Data men.

*Make note of columns that the data may contain more then 2 pieces of data, such as last names that are separated by a space, not a hyphen.

In Step 1 – Select Delimited as the Original Data Type

and click Next.

In Step 2 – Select Space as the Delimiters

and click Finish.

Save the spreadsheet.

Your spreadsheet will now have separated columns and you

can continue the process of uploading the spreadsheet into your

Fugent address book. 

Related solutions: Address Book Import