Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Organizing list of contacts in .xlsx
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 a 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Organizing list of contacts in .xlsx
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export contacts from Excel back to Outlook Contacts? | Excel Discussion (Misc queries) | |||
Re-organizing list information into filterable table | Excel Discussion (Misc queries) | |||
Exporting Contacts list to Excel | Excel Discussion (Misc queries) | |||
Moving contacts from one list to another | Excel Discussion (Misc queries) | |||
populating list box with contacts | Excel Programming |