Extract a mobile number from string AND remove the spaces?

I have thousands of these that need cleaning from a very poor dataset.

Examples:

01695 557086 07976 064 189
01689/ 608455/07818 030821


I need to extract just the UK mobile phone number so my result looks like this:

07976064189
07818030821

Can that be easily done?

Thanks in ad

This will work based on your sample.

Try:

=RIGHT(SUBSTITUTE(A1," ",""),11)

Wow, fast reply, thanks so much that worked perfectly!

How would I modify this formula to account for the following example please:

0121 555 6011 07739 065138

This has 2 spaces in the mobile number so I would the formula you posted above to remove both single, and double spaces too.

You're welcome, happy to help.

The formula from post #2 removes all spaces regardless of how many there are or if they are single, double, triple, etc.

Excellent thanks again, my workbook is so large that it took a while to process everything. Your formula works just how you described!

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.