I have imported from the web a spread sheet in CSV (comma delimited) formating. However instead of having multiple columns for address 1, address 2, city, state and zip, there is only one column. The entire addres in is one cell for each entry. Therefore everything in quotes below is in one cell.
"1900 South State College Blvd
Suite 600
Anaheim, CA
USA, 92806"
Each line is seperated with an alt + enter.
What I want to do is apply a formula or something so that each line becomes its own cell on one row.
Eg.
Column C Column D
1900 South State College Blvd Suite 600
Please help thank you
"1900 South State College Blvd
Suite 600
Anaheim, CA
USA, 92806"
Each line is seperated with an alt + enter.
What I want to do is apply a formula or something so that each line becomes its own cell on one row.
Eg.
Column C Column D
1900 South State College Blvd Suite 600
Please help thank you