ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   parsing text field based on commas or spaces (https://www.excelbanter.com/excel-programming/314446-parsing-text-field-based-commas-spaces.html)

Excel User

parsing text field based on commas or spaces
 
Is there a way to parse a text field (different lengths) based on spaces or
commas within the field? Thank you!

Frank Kabel

parsing text field based on commas or spaces
 
Hi
have you tried 'Data - Text to columns'?

In VBA have a look at the Split method (not available in Excel 97
though)

--
Regards
Frank Kabel
Frankfurt, Germany

"Excel User" <Excel schrieb im
Newsbeitrag ...
Is there a way to parse a text field (different lengths) based on

spaces or
commas within the field? Thank you!




All times are GMT +1. The time now is 03:30 PM.

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