ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Seperating Text from Columns (https://www.excelbanter.com/excel-discussion-misc-queries/136569-seperating-text-columns.html)

Johnny B[_2_]

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


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com