Looking to paste a word over a range cells and add a number at the end.

**NWR1Games** · 11-19-2014, 10:12 AM

Hello,

I'm looking to paste a word vertical over a range of cells and add a number at the end of each of the words. For example,
A1: Bus01
A2: Bus02
A3: Bus03

At the moment I'm entering this manually over 300 cells on a couple of sheets and it's time consuming.

I can provide more information if so.
Thanks

**bmouse** · 11-19-2014, 10:32 AM

Posted my answer in the main forum.

**newdoverman** · 11-21-2014, 02:29 PM

Enter Bus01 in A1

Click on cell A1 and with the mouse grab and hold the little fill handle on the lower right of the cell and drag down the column. The Bus will be repeated but the number will be incremented with each row.