Home » Forums » Open Source Learning Center » Question and Answer

Excel - change the last character in a cell in increasing alphabet down a column

Submitted by piynik on 28 January, 2016 - 12:59

Hi I want to change the last character in each cell in increase alphabet down a column, for example in a column I have

1234A
1234B
1234C
1234D
etc

How do I use a formula so that I can hold Ctr+Down to fill down the column while it automatically changes the last character in alphabetical order (A,B,C,D,E so on)?

Thanks!

‹ Copying specified columns from one workbook to a separate workbook containing uniquely named columns in another workbook. Splitting a data in a cell into multile cell. ›
»