converting

This is what I have in Excel, rows of addresses: John Doe | 123 Anystreet | Anytown, NY 12345 Mary Doe | 123 Anystreet | Nowhere, NY 22333 This is how I want it to appear in Word, a single column of addresses: John Doe 123 Anystreet Anytown, NY 12345 Mary Doe 123 Anystreet Nowhere, NY...

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

We often get spreadsheets from our customer that are formatted with both comma and dash combinations. We would like to only have the comma seperation. Example: R1, R2, R3-R5, R30 Result: R1, R2, R3, R4, R5, R30 There is usually only one alpha character but sometimes more. Example: CR1, CR2...