three digits
 

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22

three digits
 

A1 = 5 digit number
=value(LEFT(A1,3))

If this post helps click Yes
---------------
Jacob Skaria


"MFS" wrote:

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22

three digits
 

try,

=left(a1,3)

mike

"MFS" wrote:

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22

three digits
 

Hi MFS,

You can use following function, assuming you have the data in cell A1:-
=VALUE(MID(A1,1,3))

Note: - In the formula, you can increast "3" to get more and less numbers
picking up. Thanks.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"MFS" wrote:

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22