parsing words in a cell separated by commas

[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.

 

[Mike Tomasura]

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.

 

[Tom Ogilvy]

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