Excel: Extracting a postal code from an address column into a separate column using formula


Hi All Could anyone please help to advise how to extract a postal code from an address column into a separate column using formula? Here is a sample of what seems to be 4 different variations of the data:

JOHOR BAHRU JOHOR 80250 M'SIA
86800 MERSING JOHOR M'SIA
DI JALAN AMPANG
JALAN NB2 10/2 , TAMAN NUSA
The postal code is not in a fixed position as you can see in line 1(80250) and line 2(86800). Line 3 does not have a postal code and line 4 doesn't either but it has other numbers(also not in a fixed position) which is part of a street name. What seems to be consistent is that the postal code is always a 5 digit number. Your advice would be very much appreciated. Yours truly, Amir A


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of March 02, 2014.


For more resources for Microsoft Excel