Extract 6 digit numbers from Street address

[arrowedman]

Hi,

I need help extracting 6 digit numbers from street address.

The problem is the format of the address is not always the same.
e.g. 65 ABERDEEN AVENUE DALLAS TEXAS 752307 UNITED STATES
7 Cecil Street Singapore 048547

Thank you!

 

[pgc01]

Hi arrowedman
Welcome to the board

Please spend some time looking at your problem and give a clear and thorough explanation of what you need.

It's not ok to have people spending time trying to help you, and finding out that they are working on wrong information.

You stated clearly in your post:

I need help extracting 6 digit numbers from street address.

How is it that your example now has no 6 digit number to extract?

Or was it just a typo in the example?

 

[Ruddles]

I encountered the error: "Ambiguous name detected: SixDigits"

You have the same code appearing more than once in your workbook wih the same name. VBA is telling you that it doesn't know which one you're referring to. Check all your code modules and make sure the code only appears once in your workbook.

 

[swastik]

Sir you are great. What a beautiful solution.