parsing words in a cell separated by commas

  • Thread starter Thread starter spjoseph0511
  • Start date Start date
S

spjoseph0511

does any one know how to loop thru and extract words in a cell separated
by commas? the number of words will change and they will need to be
trimmed (and pasted into other cells). any help will be greatly
appreciated.
 
That sounds like a CSV file (comma delimited).
Paste the data into notepad and save the file with the extension .csv
Excel will do the rest for you when you open it.
 
if the strings are in one column, try use Text to Columns under the data
menu.
 
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

Add Values in a comma separated cell to combobox 2
Parsing Address, City ST ZIP 7
VBA set thick borders around non empty cells in range 0
Why does Excel think this is a number? 6
Separating Commas in an Excel field 1
How to parse UDF arguments? (separators are localized) 3
Comm-separated output to a csv file 1
Parsing after multiple selection in drop-down? 10

Back
Top