As both examples with zip codes relate to Florida, you could put this in E2:
=IFERROR(MID(D2,FIND("FL",D2)+3,5),"")
then copy down.
Hope this helps.
Pete
As both examples with zip codes relate to Florida, you could put this in E2:
=IFERROR(MID(D2,FIND("FL",D2)+3,5),"")
then copy down.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks