View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny B[_2_] Johnny B[_2_] is offline
external usenet poster
 
Posts: 20
Default Seperating Text from Columns

Hey guys, Greg Wilson answer my question excellently last time! Thanks!
But I have another similar confusing question. How would you separate only
the FIRST 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