Insert the same word at the start of a column of cells

[Ann]

I have a column of descriptions and want to insert the word Muratec in front
of each description. Does anyone know how to do this?

 

[Don Guillett]

try

Sub addtext()
For Each c In Range("e2"). _
Resize(Cells(Rows.Count, "e").End(xlUp).Row - 1)
c.Value = "Muratec " & c
Next c
End Sub

 

[Ann]

Where do I type in Sub addtext()
--
Thanks,
Ann

try

Sub addtext()
For Each c In Range("e2"). _
Resize(Cells(Rows.Count, "e").End(xlUp).Row - 1)
c.Value = "Muratec " & c
Next c
End Sub

 

[Don Guillett]

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

Where do I type in Sub addtext()