+ Reply to Thread
Results 1 to 3 of 3

trim

  1. #1
    geza
    Guest

    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. #2
    Ron de Bruin
    Guest

    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. #3
    geza
    Guest

    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

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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