Getting the first 3 digits out of 6 digit cells?
 

I have a 6 digit number in a cell. I want the first 3 digits of it to appear
in another cell. What is the formula?

=LEFT(A1,3)*1

Or, to make it a little more robust:

=IF(LEN(A1)<3,"",LEFT(A1,3)*1)

Biff

"Darla" wrote in message
...
I have a 6 digit number in a cell. I want the first 3 digits of it to
appear
in another cell. What is the formula?

=LEFT(A1,3)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Darla" wrote in message
...
I have a 6 digit number in a cell. I want the first 3 digits of it to
appear
in another cell. What is the formula?

Darla Wrote:
I have a 6 digit number in a cell. I want the first 3 digits of it to
appear
in another cell. What is the formula?

Hi Darla

Try =MID(A1,1,LEN(A1)-3) in cell A2 if 6 digit no in A1, change cell
references to suit


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467682

One mo

=INT(A1/1000)



Darla wrote:

I have a 6 digit number in a cell. I want the first 3 digits of it to appear
in another cell. What is the formula?

--

Dave Peterson

Just to be different:

=Quotient(A1,1000)

--
Dana DeLouis
Win XP & Office 2003


"Darla" wrote in message
...
I have a 6 digit number in a cell. I want the first 3 digits of it to
appear
in another cell. What is the formula?