Hey all,
I know this is possible because I had it working but saved as CSV and lost all my formulas. And now can't get it working again.
I would like to extract the first two characters after the last instance of a space in its own column if the rightmost character contains 7 digits ( hence FL will be in its own column). If the length of characters after last space does not contain 7 characters, then that means it's Canada and I would like to put the first two characters (CA) in an entirely separate column that contains the states. This would be the country column.
WEST PALM BEACH FL33416
FORT LAUDERDALE FL33309
RAHWAY NJ07065
ORLAND PARK IL60467
VAUGHAN ON CAL4K 1
Thanks for any response.
Bookmarks