Trim Function

[Guest]

Hello from Steved

I have 4 numerals say 1234 what trim function would I use please to return
a 3 numeral value ie 123

Thankyou.

 

[Biff]

=LEFT(A1,3)*1

Biff

 

[Guest]

Thanks Biff

=LEFT(A1,3)*1

Biff

 

[SuperDave]

Or divide by 10 and truncate to an integer...

 

[Guest]

Hello SuperDave from Steved

Could you please give me an example ie 1234 to 123 using divide by 10 and
truncate to an integer

Thankyou.

 

[JE McGimpsey]

One way:

=INT(1234/10)

Hello SuperDave from Steved

Could you please give me an example ie 1234 to 123 using divide by 10 and
truncate to an integer

Thankyou.