Hi
This should not be difficult. I have a list of cities State letters and zip in the US.
I want to extract from the right a specific number of characters. so that I have the zip code.
I have
South Bend, IN 46628
Evansville, IN 47712
Washington, IN 47501
Mishawaka, IN 46545
I want
46628
47712
47501
46545
And then
IN
IN
IN
IN
Obviously if I can get the first then the second will be a repeat.
Thanks
Mark
Bookmarks