How to convert single column of addresses in MS Word into 3 columns in MS Excel

[exceltm]

I have a list of addresses in MS Word, in a single column, such as

John Doe
123 Anystreet
Anytown, NY 12345

Mary Doe
123 Anystreet
Nowhere, NY 22333

etc

I want to convert each vertical address in Word into a horizontal address in Excel so it looks like this in 3 columns:

John Doe | 123 Anystreet | Anytown, NY 12345
Mary Doe | 123 Anystreet | Nowhere, NY 22333

I don't want to use a macro, as I am not skilled in them.

 

[Misca]

Try using Find And Replace techniques in Word:

MS Word allows the "carat p" symbol ^p (carat is the <shift> 6 key) to represent a carriage return in an MS-Word replace command. First try replacing the empty lines (= hopefully done with a double carat space = ^p^p) between the addresses by something else. Just make sure it's something that won't be found anywhere in the addresses.

That being done you can replace the single carat spaces with a single character you won't find anywhere in text (try using "å", "ä" or "ö" for example).

Now replace the unique text you used to replace the double carat spaces with a single carat space.

Now all you have to do is copy the addresses to Excel and use the Text To Columns with the unique character as the delimiter.