Returning 10 digits from text string?

[mucusboy]

I have a formula which has worked perfectly for some time, but I now have some variables in my source data and am struggling to amend it.

Essentially I need to search a string of text and return a 10 digit number. Previously this always started with a “41” so I could use the formula:

=IFERROR(LEFT(TRIM(RIGHT($W4,(LEN($W4)-SEARCH("41",$W4)+1))),10),"")

There’s probably a cleaner way of doing this I know…

However, the 10 digit number may now start with either a “41”, “42”, “91” or “92”. I am really not sure how I can amend to find the solution. Can anyone help?

 

[sergioMabres]

Always glad to help!

 

[mail2master]

Thanks for your reply! I couldn't get this to work and kept returning #VALUE !

Did you confirmed with Ctrl+Shift+Enter ?? This is an array formula so, won't work with just Enter.