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/