trim

[Guest]

Heloo everyone,

I am looking for a simple formula: in a column of numerical values such as
50405, how would i get rid of the last two numbers, i.e from 50405 to 504.

Thank you,

Geza

 

[Ron de Bruin]

Try this formula

=--LEFT(A1,LEN(A1)-2)

 

[Guest]

Thank you Ron.

Try this formula

=--LEFT(A1,LEN(A1)-2)