Splitting fields from commas
 

Try this:

1)Select your column of text
2)DataText to Columns
-Delimited...............[Next]
-Check Comma......[Finish]

If you don't like what you get...just Undo.

Does that help?

Regards,
Ro

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=38135