Hi,

If you have the number of characters limited including space then try this
=MID(A3,9,20)
For eg. MR Frank is 8 digits including space if all the names are of 8
digits then you can use this. (20) actually refers to the number of character
that excel will return you can change it if you feel the characters are not
complete.
--
Thanks
Suleman Peerzade


"SIAMAK" wrote:

I WANT TO SEPARATE NUMBERS FROM TEXT IN A CELL ; LIKE:
A1: MR FRANK (25687)
A2: MR FRANK 256875787
A3: MR FRANK (256875) AT2008/2/6
A4: MR FRANK 2560 IN U.S
A5: 25602MR FRANK
THANK YOU.