Forum Discussion

tonmoy6794's avatar
tonmoy6794
Copper Contributor
Jan 17, 2024

How to change or replace multiple cell name in Microsoft Excel chronologically?

I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2", the third one will be "transfer 3" and so on. Is that possible? If so how and is there a easy method to do that? Also if that is not possible, is there a way to arrange the cell of Column A same as Column B. i.e arranging the cells of column A exactly like column B and have those blank cells in between.

I am complete noob at excel so please be detailed with your answers if possible. Thank you.

 

I have tried several formulas and methods but none of them gave me the desired result that I expected. I have not tried VBA though because I dont know how to use it.

 

Charting
excel
Excel for web
Formulas and Functions
office 365

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 17, 2024
    In column C, enter this formula: =INDEX($A$1:$A$19,COUNTA(B1:$B$1))
    Copy down as far as you have data in column B.
    Then do this:
    - Select column B
    - Press the F5 function key
    - Click Special
    - Select "Constants"
    - Click OK
    - press the = sign on your keyboard
    - Click on cell C1
    - Press control+Enter
    - Now select column B again and click Copy
    - Press Control + Alt + V to bring up the paste special dialog and paste Values only.

Resources