seperate city, state & zip from one cell

[vikkam]

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
(e-mail address removed)

vikkam
(e-mail address removed)

 

[Earl Kiosterud]

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]

Earl

Thanks for your reply.

vikkam