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

If it just 3 numbers always to the left, then use

=LEFT(A1,3) or

=LEFT(A1,3)*1 to format it to a number


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61197