Reduce string to a certain amount of characters

[Jholiday78]

Greetings,

I am looking to reduce a customers account number to just 10 characters to join to another set of data where the account number is only 10 characters. 

It has leading zeros, so I need to keep some, but not all.  My main objective is to go from 12 characters to 10 characters.  Can this be accomplished in a formula tool?

Here is an example:

Customers#                   Desired Output

000036545705              0036545705

Jessica

[Qiu · Accepted solution]

@Jholiday78 
We can use the Right function and set the length to be 10.

[Jholiday78]

Worked like a charm.  Thank you!

[Qiu]

@Jholiday78 
Good to know it helps. 😁