Organizing list of contacts in .xlsx

[matthew.elias]

I have an excel spreadsheet with contact information for roughly 800
people. I would like to get this information into a more usable
format for email clients, etc. Doing this manually for this list
would be extremely time consuming. Each entry has information for
both the company and the contact.

The first issue is the format. The list is in 2 columns and some
entries have more rows than others. The spreadsheet is currently
formatted as follows:

Column A
Organization Name
Organization URL
Organization Address1 (Street)
Organization Address2 (City State Zip)

Column B
Contact Name
Contact Phone
Contact Fax
Contact Email (in hyperlink displayed only as contact's name)

My questions are:

1. Is there any way to separate each field into it's own column?
2. Can I remove the display names to only display the email address
(and not the contact name hyperlinked to the mailto: address)?

Thanks in advance for any help!

Matt

 

[michael.beckinsale]

hi Mathew,

Difficult to provide a proper answer based on details posted but this
might point you in the right direction.

Assuming the data has been imported / copy & pasted into Excel it is
likely that that each 'field' is seperated by a charcter (delimiiter),
hence you have might have several lines in each cell. Use the 'text to
columns' under 'data' to split this information across columns. Use
it again to split email / hyperlink.

There are many articles on this subject in this newsgroup.

HTH

Regards

Michael