Figured out the solution using a macro.
Another problem that I'm facing is I would like to extract postcodes from a line of address and all postcodes have 5 digits.
Hence from a small part from the worksheet:
Code:
Bukit Jalil Integrated Business Park, Mukim Petaling 58200 Kuala Lumpur
Kawasan Perusahaan Bangi, 43650 Bangi Selangor Darul Ehsan
No 2, Jalan Kuning, Taman Pelangi, 80400 Johor Bahru Johor Darul Takzim
Would like it to just appear as:
Is there any wildcard for number only? I don't think it is possible to use a formula considering the position of the postcode varies from one cell to another. Any suggestions?