| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
