# trim

1. ## 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

2. ## Re: trim

Try this formula

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

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

"geza" <geza@discussions.microsoft.com> wrote in message news:16BD18A0-C09E-4D06-B151-489522EE542E@microsoft.com...
> 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

3. ## Re: trim

Thank you Ron.

"Ron de Bruin" wrote:

> Try this formula
>
> =--LEFT(A1,LEN(A1)-2)
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "geza" <geza@discussions.microsoft.com> wrote in message news:16BD18A0-C09E-4D06-B151-489522EE542E@microsoft.com...
> > 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

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1