Hi,

If they are consistantly 3 numbers followed by 3 letters, you can
1. Choose the Data, Text to Columns command and follow the wizard
2. =--LEFT(A1,3)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JJ" wrote:

I have data like these: 123ABC, 456EFG
Is there any way to return just number from those cells? How to do it? Thx.