![]() |
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! |
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