Seperating Text from Columns
Hi Johnny B,
Go to data and choose TEXT TO COLOMNS. Follow the instructions.
Hope this will help.
Regards
Albert
"Johnny B" wrote:
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
|