Lookup number in text string

[retboell]

Hi,

I'm searching for a solution to lookup and return the number of a cell/text string. Example:

Input	Return
asd-1234567890123axbf	1234567890123
1234567890123_00sajs1	1234567890123
0-1234567890123sdfjquwe	1234567890123
asdasd-1-n1234567890123	1234567890123

<colgroup><col><col></colgroup><tbody>
</tbody>

The number will always start with 12345 (but the rest varies) and will always be 13 digits. Otherwise it can be mixed with other numbers and text in the cell (see example)

Help is much appreciated!

 

[lezawang]

"hi-jacking" someone else thread!! no you are wrong, that was not the intention. I thought it is wrong to open a new thread when the topic we are discussing is about the code in this thread.
Anyway thanks for your suggestion.

 

[Michael M]

@lezawang
The topic of this thread was about extracting numbers from a string !
While you questions may relate to a post within that thread, they are not related to the topic as such.
Answering you first question is deemed ok, but by continuing the thread in another direction, ie, further questions about coding and not about extracting numbers from a string, is in fact, hijacking.
Not a pleasant term, but it detracts from the original question and then that user gets pushed into the background.

 

[lezawang]

Ok got it. Thanks for the clarification. I see the point now. Thank you.

 

[Michael M]

no worries...

 

[philwojo]

Retobell (OP), did the formula in post #2 work for you, or do you still need help?