Find and Isolate a specific number within a text cell.

Hi All,

I am new to the forum, familiar with working in excel and just beginning to learn VBA.

I have a customer information spreadsheet of over 1200 entries and different attributes. Each customer row has a physical address attribute. Since, all the customers are within my city, their physical addresses have a pin-code between "500000 and 500200"(Infact, there are under 10 instance of pin values more than 500099). The same is highlighted in the image attached.

My objective is simple. I want to find and isolate the pin values from each address and load it into a new cell.

Kindly help me solve this problem in the simplest way possible.

Thanks.Pincodes in Address fields.png