Most valuable professional
  • Hot Topics

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 Last edited by Amir A; Mar 2nd, 2014 at 01:50 AM. Reason: Sorry, the alignment was awful earlier and took up to many lines. Have amended to save the number of lines used

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

This thread is current as of March 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel