How to Split the addresses

[niladri20005]

Hi All,

I am facing one challenges when I am going to split the addresses as Street City State and Postal code wise. I have the addresses in one cell with three Line like below:

12 Daniel Rd East, 3rd Floor
Fairfield, NJ 07004

12647 Alcosta Blvd., STE 165
Bishop Ranch Business Park 15
San Ramon, CA 94583

How will i get these in one line like

12 Daniel Rd East, 3rd Floor Fairfield, NJ 07004

if I get these in one column then it will be better for me to put a comma then I will split these addresses with TEXT to column.

Is there any any way to get these addresses in one line?

Thanks in advance!

[outofthehat]

The line feed character (Alt-Enter) is ascii character 10, so you should be able to use SUBSTITUTE to put commas in instead, e.g.

Please Login or Register  to view this content.

[Armando Montes]

Select the cell with the multiple lines, use Data/Text-to-columns, click in
the "Other" checkbox in step 2, hold the Alt key down, press 010, let go of
the alt key, click OK.