I have a text string that is in all one cell and I want to convert
portions of the string into seperate cells. Can anyone help me with
the formula for that?
Here is what the string looks like:

ALLEN, BILL,"9654 N 6620 W",,"CASEYVILLE","AZ","84487"


I need each of the name, address, city state and zip in sererate
cells.
thanks!


--
billyccarver
------------------------------------------------------------------------
billyccarver's Profile: http://www.excelforum.com/member.php...o&userid=28265
View this thread: http://www.excelforum.com/showthread...hreadid=478262