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|
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of March 02, 2014.