Apr 25 2021 03:20 AM
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
Apr 25 2021 03:28 AM - edited Apr 25 2021 03:30 AM
@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.
Apr 25 2021 03:35 AM
Apr 25 2021 03:41 AM
@balarabe1876 See example attached.
Apr 25 2021 03:46 AM
Apr 25 2021 10:06 AM
Apr 26 2021 11:20 PM
Apr 27 2021 03:14 AM - edited Apr 27 2021 03:14 AM
Not sure I understood. What exactly means "add it back later"?
Apr 27 2021 03:34 AM
Apr 27 2021 04:08 AM - edited Apr 27 2021 04:08 AM
@balarabe1876
Still didn't catch.
To get the text without first letter =RIGHT(A1, LEN(A1)-1) (let say in B1)
To keep first letter is =LEFT(A1) (let say in C1)
Combine back together =C1&B1 (let say into D1)
Apr 27 2021 04:24 AM
Apr 27 2021 09:22 AM
Glad to know that helped you.