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 |
| H0047694736 |
| H0047694744 |
| H0047694752 |
| H0047694760 |
Thank to anyone that can help.
Best Regards
11 Replies
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.
