Forum Discussion
Need help with large data(serial Numbers)
Hello I require help to remove last digit on a worksheet. Example below H0047710359 H0047710383 H0047710405 H0047710421 H0047927587 H0047927668 H0047927676 H0047927692 H0...
balarabe1876 If you mean that you want to remove the last digit for every cell, try this:
=LEFT(A1,LEN(A1)-1)
where A1 is the first cell with the "H004......." code. Copy it down as far as needed.
- Thank you sir.
Am i going to insert it in the cell or how do i effect itbalarabe1876 See example attached.
- THANKS A BILLION SIR.
VERY APPRECIATIVE HERE.
THANKS
