How can I remove the trailing "1" from a worksheet.

Discussion in 'Excel Charting' started by thecjguy1@gmail.com, Feb 23, 2013.

  1. Guest

    I have a long column of numbers some large numbers, but they all have a "1" at the end.
    How can I use excel to truncate the trailing digit from every entry?
    for instance.
    801
    1761581
    etc...
    should read
    80
    176158

    Thanks,
    Crzzy1
     
    , Feb 23, 2013
    #1
    1. Advertisements

  2. Claus Busch Guest

    Hi,

    Am Sat, 23 Feb 2013 09:15:08 -0800 (PST) schrieb :

    > I have a long column of numbers some large numbers, but they all have a "1" at the end.
    > How can I use excel to truncate the trailing digit from every entry?
    > for instance.
    > 801
    > 1761581
    > etc...
    > should read
    > 80
    > 176158


    your numbers in column A:
    =--LEFT(A1,LEN(A1)-1)
    or with VBA:

    Sub CutLastDigit()
    Dim LRow As Long
    Dim rngC As Range

    LRow = Cells(Rows.Count, 1).End(xlUp).Row
    For Each rngC In Range("A1:A" & LRow)
    rngC = CLng(Left(rngC, Len(rngC) - 1))
    Next
    End Sub


    Regards
    Claus Busch
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Feb 23, 2013
    #2
    1. Advertisements

  3. Guest

    On Saturday, February 23, 2013 10:45:08 PM UTC+5:30, wrote:
    > I have a long column of numbers some large numbers, but they all have a "1" at the end.
    >
    > How can I use excel to truncate the trailing digit from every entry?
    >
    > for instance.
    >
    > 801
    >
    > 1761581
    >
    > etc...
    >
    > should read
    >
    > 80
    >
    > 176158
    >
    >
    >
    > Thanks,
    >
    > Crzzy1


    Or Simply u can keep
    =(A2-1)/10
     
    , Aug 31, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. SK Rutenbeck
    Replies:
    1
    Views:
    130
    Bernard V Liengme
    Aug 26, 2003
  2. CLS1977
    Replies:
    0
    Views:
    85
    CLS1977
    Sep 17, 2004
  3. Frank Kabel
    Replies:
    0
    Views:
    125
    Frank Kabel
    Oct 27, 2004
  4. Lee IT
    Replies:
    3
    Views:
    111
    Andy Pope
    Jan 31, 2005
  5. KLF
    Replies:
    1
    Views:
    78
  6. Replies:
    3
    Views:
    162
    Andy Pope
    Aug 24, 2006
  7. CLASSC
    Replies:
    4
    Views:
    83
    Ron Coderre
    Dec 2, 2007
  8. JayDeVo
    Replies:
    3
    Views:
    207
    Jon Peltier
    Jan 26, 2008
Loading...