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

  • Thread starter Thread starter thecjguy1
  • Start date Start date
T

thecjguy1

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
 
Hi,

Am Sat, 23 Feb 2013 09:15:08 -0800 (PST) schrieb (e-mail address removed):
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
Click to expand...

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
 
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
Click to expand...

Or Simply u can keep
=(A2-1)/10
 
Back
Top