Hi Carlos

With your 16 digit number in column A, enter in B1
="A"&RIGHT(A1)

Change the "A" to the letter(s) of your choice.

Regards

Roger Govier


Carlos wrote:
In excel I need to take the last digit of a 16 digit number from one column
and then write it down into another column with a letter in front of it