Forum Discussion
tonmoy6794
Jan 17, 2024Copper Contributor
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...
JKPieterse
Jan 17, 2024Silver Contributor
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.
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.