J
JB1981
Hi All ~
Need to separate this kind of data into 3 fields
Los Angeles, CA 90038
I found this bit of code which ALMOST does what i need it to
For the city, use
=LEFT(A1,FIND(",",A1)-1)
For the state, use
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)
but it comes back with the State and Zip still in the same field and
there is no coma between I can use to select. Is there a way to get it
to grab only numbers?
THANKS!
JB
Need to separate this kind of data into 3 fields
Los Angeles, CA 90038
I found this bit of code which ALMOST does what i need it to
For the city, use
=LEFT(A1,FIND(",",A1)-1)
For the state, use
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)
but it comes back with the State and Zip still in the same field and
there is no coma between I can use to select. Is there a way to get it
to grab only numbers?
THANKS!
JB