View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
albertmb albertmb is offline
external usenet poster
 
Posts: 81
Default 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