Seperating Text from Columns
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 |
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 |
All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com