I have cells in column A that contain info as shown below, where the property address includes a zip code. This zip code can be one of seven different option, but always 5 digits.
I need a function that says:
IF the cell contains zipcode1
, zipcode2
, zipcode3
, etc., then copy that zipcode to the next cell over.
Any help?
Dispatch Type: ********
Service Fee Due : ********
Urgency : ********
Service Fee Paid: ********
Net To Collect : ********
Dispatch ID : ********
Dispatch Date: ********
Item 17822 : ********
Customer: ********
Property Address: ********
Dispatch Contact(s):
Copyright Notice:Content Author:「Desmond Tatilian」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/30771599/spreadsheet-formula-extract-zip-code-from-address