I have a spreadsheet that includes something like, "Beverly Hills 90210", what's the easiest way to separate the one field into two fields (city and zip)? I've attempted Text to Columns, separating by space, but because the city names are not consistent, it isn't very simple. But I can separate the zip by using the =RIGHT formula, having trouble with the city.
Last edited by mcmuney; 01-12-2011 at 06:37 PM.
If the ZIP is always 5 digits on the right and preceded by a space, for ZIP use:
=RIGHT(A1,5)
And for city use:
=LEFT(A1,LEN(A1)-6)
HTH,
Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks