seperate city, state & zip from one cell

vikkam · Oct 28, 2003

I have a databse which has city, state and zip in one cell (column)

If I want to seperate in 3 different columns how to do it ?

Thanks much

I will appreciate if you can e-mail your suggestion to
[email protected]

vikkam
[email protected]

Earl Kiosterud · Oct 28, 2003

Vikkam,

If your addresses are well-behaved (all have a comma after the city, a space
after the state, etc., this may work:

=LEFT(A2,SEARCH(",",A2)-1)
=MID(A2,SEARCH(",",A2)+2,2)
=MID(MID(A2,SEARCH(",",A2)+2,999),SEARCH(" ",
MID(A2,SEARCH(",",A2)+2,999))+1,999)

Earl Kiosterud
mvpearl omitthisword at verizon period net

vikkam · Oct 29, 2003

Earl

Thanks for your reply.

vikkam