View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Try something like this, Carlos, assuming your 16-digit number is in column
C:

="A"&right(C2,1)
That'll add the letter A to the last character in C2

************
Anne Troy
www.OfficeArticles.com

"Carlos" wrote in message
...
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