Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert address block into delimited rows?
Not sure if this should go in Word or Excel but here's the deal...
I have a document in Word that contains a bunch of address in the format of Name Address City, State, Zip Telephone Website After each internal line is a line break and after the last entry is a paragraph return if that makes it any easier. I want to get them into Excel in the format of: Name, Address, City, State, Zip, Telephone, etc Anyone know of an automated way to do that? Maybe some sort of import or export or something that I can do? Just don't want to have to do it all manually. Thought I could do a find and replace and turn the line breaks into commas or something maybe but don't kow how to do a find on a special character like that. Also, not all addresses have all the fields. Some have websites, some don't. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert address block into delimited rows?
All example data is in one cell?
Try DataText to ColumnsDelimited byOther Hit CTRL + j for line breaks. Finish to break into columns. You will then select City, State, Zip column and split that into 3 by using delimited by comma. Don't forget to insert a couple of blank columns to the right first. Gord Dibben MS Excel MVP On Fri, 24 Jul 2009 08:28:01 -0700, Mr B wrote: Not sure if this should go in Word or Excel but here's the deal... I have a document in Word that contains a bunch of address in the format of Name Address City, State, Zip Telephone Website After each internal line is a line break and after the last entry is a paragraph return if that makes it any easier. I want to get them into Excel in the format of: Name, Address, City, State, Zip, Telephone, etc Anyone know of an automated way to do that? Maybe some sort of import or export or something that I can do? Just don't want to have to do it all manually. Thought I could do a find and replace and turn the line breaks into commas or something maybe but don't kow how to do a find on a special character like that. Also, not all addresses have all the fields. Some have websites, some don't. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert excel (.xls) to tab delimited (.txt) without double quotat | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
Address block carriage returns not correct | Excel Worksheet Functions | |||
tab delimited file convert to columns | Excel Discussion (Misc queries) | |||
Mail Merge creates a space in the address block | Excel Discussion (Misc queries) |