parsing words in a cell separated by commas
 

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.


---
Message posted from http://www.ExcelForum.com/

parsing words in a cell separated by commas
 

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.


"spjoseph0511" wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

parsing words in a cell separated by commas
 

if the strings are in one column, try use Text to Columns under the data
menu.

--
Regards,
Tom Ogilvy


"spjoseph0511" wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/