pick out only the numbers

[niladri20005]

Hi All,

I have list consisting of Number and Text. Like below

01234ONTP687
2356TR4892
6758OPTYE5689
9252715678 ext1

How will I get only the numbers? I do not want in the cell.

[niladri20005]

PLEASE IGNORE MY PREVIOUS POST

Hi All,

I have list consisting of Number and Text. Like below

01234ONTP687
2356TR4892
6758OPTYE5689
9252715678 ext1

How will I get only the numbers? I do not want TEXT in the cell.

[Colin Legg]

For reference, cross-posted at MrExcel:
http://www.mrexcel.com/forum/showthread.php?t=564963

[arthurbr]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

[nawas]

Check out the below link

http://office.microsoft.com/en-us/ex...001154901.aspx