I need to insert a marker (like "/") between a zip code and an occupation in a text cell in order to separate the text into two cells. How can I devise a formula that will "find" the 5-digit zip code, then insert a marker after the zip? Help!
Before:
221 South Union # 1 Jackson MO 63755 Lutheran Pastor
After:
221 South Union # 1 Jackson MO 63755 / Lutheran Pastor
Before:
221 South Union # 1 Jackson MO 63755 Lutheran Pastor
After:
221 South Union # 1 Jackson MO 63755 / Lutheran Pastor