J
Joanne
My file has city st zip all in one cell, such as
Chicago IL 60000
No commas to look for to do the typical separation
I tried using =LEFT(C2,FIND(" ",C2)-1) to find the first blank space
and it works, but then some cities have 2 words in their name so that
is also no good.
I was thinking I could come in from the right, grab the zip by
locating the first space from the right and moving it, then go again
to get state, then again to get city. Problem is that I need to not
only copy the element to its own cell but to delete it from the
original cell so that I can find the next element. Can this be done,
the deletion of the elements after the copy? Or can I do it by
looking for the second blank space on the second run thru and somehow
grabbing what is between the first and second empty space?
Any help you can give me will be appreciated.
Thanks
Joanne
Chicago IL 60000
No commas to look for to do the typical separation
I tried using =LEFT(C2,FIND(" ",C2)-1) to find the first blank space
and it works, but then some cities have 2 words in their name so that
is also no good.
I was thinking I could come in from the right, grab the zip by
locating the first space from the right and moving it, then go again
to get state, then again to get city. Problem is that I need to not
only copy the element to its own cell but to delete it from the
original cell so that I can find the next element. Can this be done,
the deletion of the elements after the copy? Or can I do it by
looking for the second blank space on the second run thru and somehow
grabbing what is between the first and second empty space?
Any help you can give me will be appreciated.
Thanks
Joanne