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 |
 |
Comments
0 comments
Article is closed for comments.