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 :
    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
     
    Claus Busch, Feb 23, 2013
    #2
    1. Advertisements

  3. Guest

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

Ask a Question

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.