Trying to Filter out TEXT in Excel 2003 and only let numbers remain?

[Taahirah]

Hi guys im using office 2003
I import emails from outlook into an excel Document;
However the only values I want imported is the numbers in the email,not the text.
I am searching for a formula or anything to enter into excel to only view the numbers and not the text values??

COULD anyone help??
I am working with large entries like 1000+ entries a day and do not have time to manually delete the text out of each and every cell.

Regards

[martindwilson]

got an example?

[Taahirah]

got an example?

Hi Martin
Thanks for the reply

An example of what would be written in each cell would be :

"User 447000000000 has not been unsubscribed from any list!!!
List of services found:"

What I need in each cell is just the number without any text:
"447000000000"

I understand I could manually edit and delete each cell but it would take me ages,,,,

Regards

[oldchippy]

Hi,

Assumming each cell starts with

"User 447000000000 has

=MID(A1,FIND(" ",A1,1)+1,FIND(" ",A1,FIND(" ",A1,1)+1)-1-FIND(" ",A1,1)) the number will still be formatted as text.