Seperating Text from Columns

J

Johnny B

Hey guys, i have a confusing question. How would you separate only the last 3
delimited texts into separate columns. For example:

|Column A|
| American Online, 123 Fake Street, California, USA 94224 |

Convert this into:

|Column A| Column B| Column C| Column D|
| American Online, 123 Fake Street | California | USA | 94224 |

Thank you for your time!,

Johnny B
 
A

albertmb

Hi Johnny B,
Go to data and choose TEXT TO COLOMNS. Follow the instructions.
Hope this will help.

Regards
Albert
 

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

Seperating Text from Columns 0
Find in Column A and Remove from Column B 3
Splitting cell contents into other columns 1
Finding info of one column and removing it from another 9
Finding Info from sheet 1 and removing only those rows from sheet 1
Two columns : Continuous two columns vs Parallel two Column 1
Find in Column A and Remove from Column B 2
Put parts of cell into separate columns 3

Top