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. |
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) |