Extract text and numbers from Cell

[asalman07]

Thank you in advance for your help.

I have in column B going down to row 10,000 numbers followed by text.

So, a cell could be like this 005067 Mr.John or like this 3056532987 Tim

The numbers can be different digit lenghts. But one thing for sure is that the text always follows the numbers.

I am trying to extract all the numbers. Is this possible?

Thanks

 

[Matt Rogers]

Hi.

Just because "find" and "search".

Why is B3 = 4 and B4 = 3
?

Regards Matt

 

[Jonmo1]

Why is B3 = 4 and B4 = 3
?

Because the space is found in the 4th character of the string in B3, and in the 3rd character in B4.
Was there some reason you thought the results should have been something other than what you see there?

 

[Matt Rogers]

Because the space is found in the 4th character of the string in B3, and in the 3rd character in B4.

Ok, that's the reason.

I only counted "out of competition".

Sorry for the disturbance.
Matt