extract postcode number into new column

[mathanraj76]

Hi..
I need help
I have data with include postcode number
I need to extract the postcode number into a new column
I have attached sample data
Postcode is five digit number

For example
A B C D E F G
NO Account No Customer Name PROPERTY ADDRESS 1 PROPERTY ADDRESS 2 PROPERTY ADDRESS 3 PROPERTY ADDRESS 4
1 06030010187950 CHUN KAI HOE NO.48,JALAN BAYU 5. TAMAN SERI BAYU, 28600 KARAK PAHANG
2 06030010421950 CHANDRAN NO.57 LADANG SABAI BAHAGIAN KEMASUL 28600 KARAK, PAHANG.


A B C D E F G H
NO Account No Customer Name PROPERTY ADDRESS 1 PROPERTY ADDRESS 2 PROPERTY ADDRESS 3 PROPERTY ADDRESS 4 POSTCODE
1 06030010187950 CHUN KAI HOE NO.48,JALAN BAYU 5. TAMAN SERI BAYU, KARAK, PAHANG 28600
2 06030010421950 CHANDRAN NO.57 LADANG SABAI BAHAGIAN KEMASUL KARAK, PAHANG. 28600



Thanks
Raj

[jindon]

Try

Please Login or Register  to view this content.

[haripopuri]

From the attached workbook, what I see is that Pin code could be in any column and any position with in the cell. There could be other 5 digit numbers which are not pin codes. If the data is not organised, it is still possible to get the output but you have to give many possible scenarios in routine.

[mathanraj76]

Thanks

U have solved my Problem
U r really expert in ms excel ..

Once again
Thanks
Raj

[jindon]

Found bug.
Logic
Last appeared 5 digit number in the row.
See the difference in Row 5 in result.
Replace the function with

Please Login or Register  to view this content.

[mathanraj76]

Thanks
It working as i want


Once again
Thanks
Raj