ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - trim (https://www.excelbanter.com/excel-worksheet-functions/29796-trim.html)

geza

trim

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)

--
Regards Ron de Bruin
http://www.rondebruin.nl

"geza" wrote in message ...
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

geza

Thank you Ron.

"Ron de Bruin" wrote:

Try this formula

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"geza" wrote in message ...
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

All times are GMT +1. The time now is 11:13 PM.