trim off some numbers

[Rita Hill]

I need a formula to return just the first 3 numbers from a cell that may contain 9 or more numbers.

How do I trim off all the extra numbers?

Thanks,
Rita Hill

 

[MrKowz]

Does the cell contain only numbers?

If so, try:
=--(LEFT(A1,3))

If is not what you need, can you please provide an example of you input and desired output?

 

[VoG]

Try

=LEFT(A1,3)+0

 

[Desu Nota from Columbus]

I need a formula to return just the first 3 numbers from a cell that may contain 9 or more numbers.

How do I trim off all the extra numbers?

Thanks,
Rita Hill

In another cell put:

=Left(A1,3)

If 123456789 were in cell A1, you would get 123.

Does this solve your problem?

 

[Desu Nota from Columbus]

Try

=LEFT(A1,3)+0

VOG,

What is the purpose of the +0 at the end? I've seen this before and haven't ascertained its relevance.

 

[VoG]

It coerces the result into a number. Without it the LEFT function returns text.

 

[Desu Nota from Columbus]

It coerces the result into a number. Without it the LEFT function returns text.

So adding --Left() and Left()+0 do the same thing?

 

[VoG]

Yes.