SOLVED

Want to add a word in all column easily

Occasional Contributor

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

 

 

Screenshot (464).png

 

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

How can i do that?

6 Replies
best response confirmed by rasedul (Occasional Contributor)
Solution

@rasedul 

In A1

=ROW() & "word"

Select column A, Ctrl + D

Select row,
F2
write word
control + intro

@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.

Thank you so much
That's Great, Thanks
Thank You