Add letters to a series of numbers in Excel

When you have a series of numbers that appear in a row there is a benefit to being able to add letters to these numbers.

For example if you were shipping four loads under the same P.O. then the first shipment would be P.O.number"a", and the second would be P.O.number"b" and this would continue until the entire order was shipped

Here are the steps to accomplish this

  • The first thing we need to do is ask the system if this number is equal to the number above
  • Enter this formula in B2 to test the value
" =if(A2=A1), "", (a2&"a"))

With this formula, every time the number changes it will produce an "a".

To increment the letter a, which is a character code, we will use the following formula

We are increasing the character code from the first character from the right by one

Now we add this character to the existing number by using this formula

=(A3&(char(code(right(B2, 1))+1)))

We combine it with the original "if" statement

=if(A2=A1), (A2&(CHAR(Code(right(B1,1))+1))), (a2&"a"))

The result is we have a series of numbers with letters added to them

Youtube video how to add letters to a sequence of numbers

MY videos are all created on Camtasia.
TechSmith Camtasia Click Here