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!