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