I am trying to parse zipcode into a separate field. A sample of
the text is printed below.
I am using the following statement, however, I am getting very
inconsistent results....it is cutting off many of the numbers.
=RIGHT(D3,FIND(" ",D3,1))
BLOOMINGTON IN 47403-4738
BLOOMINGTON IN 47401-9705
WESTPORT IN 47283-9414
INDIANAPOLIS IN 46234-5051
What am I missing? Thanks.
Bookmarks