parsing text field based on commas or spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to parse a text field (different lengths) based on spaces or
commas within the field? Thank you!
 
Hi
have you tried 'Data - Text to columns'?

In VBA have a look at the Split method (not available in Excel 97
though)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

csv with embedded commas??? 2
Parsing a string 10
How to delete commas and spaces when not needed ... S&R way, or macro way? 11
Parse a txt file and save as csv? 4
Parsing Address, City ST ZIP 7
How to parse UDF arguments? (separators are localized) 3
Parse text field based on spaces or commas or periods 1
Parsing cells to reformat a multi-entry field database 2

Back
Top