Excel: Extract text and numbers from Cell


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


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of November 17, 2014.


For more resources for Microsoft Excel