# Need help with large data(serial Numbers)

Occasional Contributor

# 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

# Re: Need help with large data(serial Numbers)

@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.

# Re: Need help with large data(serial Numbers)

Thank you sir.
Am i going to insert it in the cell or how do i effect it

# Re: Need help with large data(serial Numbers)

@balarabe1876 See example attached.

# Re: Need help with large data(serial Numbers)

THANKS A BILLION SIR.
VERY APPRECIATIVE HERE.
THANKS

# Re: Need help with large data(serial Numbers)

As variant

``=REPLACE(A1,LEN(A1),1,)``

# Re: Need help with large data(serial Numbers)

Sir,
please can you help? i need to remove the letter 'H' in the data in the cells and latter add it back.
I will appreciate all the help.

Best Regards
@balarabe1876

# Re: Need help with large data(serial Numbers)

Not sure I understood. What exactly means "add it back later"?

# Re: Need help with large data(serial Numbers)

What i mean is that i want to remove the letter H, work on the data and add the H back after
Best Regards

# Re: Need help with large data(serial Numbers)

@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)

# Re: Need help with large data(serial Numbers)

SERGEI YOU ARE AN ANGEL.
THANKS IT WORKED

# Re: Need help with large data(serial Numbers)

Glad to know that helped you.