Want to add a word in all column easily

[rasedul]

I want to add a word in my all column there are about 10M column, is there any option in Microsoft Excel?

Like
1word
2word
3word
4word
.
.
.
.
etc.

How can i do that?

[#2 · Accepted solution]

@rasedul 

In A1

=ROW() & "word"

Select column A, Ctrl + D

[#3]

Select row,
F2
write word
control + intro

[#4]

@rasedul 

Sub word()
Dim i As Double
Dim j As Double
For i = 1 To 100
For j = 1 To 50
Cells(i, j).Value = i & "Word"
Next j
Next i
End Sub

Maybe with simple VBA code.

[#5]

Thank you so much

[#6]

That's Great, Thanks

[#7]

Thank You