Question about formatting addresses

G

garriott

Question about formatting addresses

I have a big column of addresses

John Doe
123 main St.
Portland, OR 97227

Jane Doe
123 main St.
Portland, OR 97227

I want to format them so they are in their own column

John Doe | 123 main St. | Portland, OR 97227
Jane Doe | 123 main St. | Portland, OR 97227

Is there an easy way to do this?

Please help.

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset function with inconsisent data location 1
How to format imported data 4
extracting data from one format to a different format... 2
Complex Formula to Find Doubles 7
Converting rows to columns on a large scale 1
How do I insert page breaks in a huge EXCEL file? 4
formula for database search - is it possible? 7
Getting Names and Addresses into Address Book / Contact List 1

Top