Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address List
I have a word document that is a list of 1000's names, addresses,
phone#'s,Fax#'s, I would like to sort this so each goes into correct column of a spreadsheet names in one, address in the next and so on. Can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address List
If you pasted them from word into excel and they are all in a single column
and If they the various components are separated by a delimiter then Look at Text to Columns under the data menu. If not, it would be difficult. -- Regards, Tom Ogilvy "Jessicajsh" wrote in message ... I have a word document that is a list of 1000's names, addresses, phone#'s,Fax#'s, I would like to sort this so each goes into correct column of a spreadsheet names in one, address in the next and so on. Can this be done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address List
One more assumption - all the information is in a single row.
If they are on multiple lines, then it would be more complex. Especially if the data occupied varying numbers of rows. -- Regards, Tom Ogilvy "Jessicajsh" wrote in message ... I have a word document that is a list of 1000's names, addresses, phone#'s,Fax#'s, I would like to sort this so each goes into correct column of a spreadsheet names in one, address in the next and so on. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
Transpose list of address into rows for mailing list | Excel Discussion (Misc queries) | |||
address list | Excel Discussion (Misc queries) | |||
Address list | Excel Discussion (Misc queries) | |||
long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) |