Inserting a word

D

Daniel

Hi

I have a row of cells, each with a different word, being part of a
description.
I need to insert a word, the same word, in front of the words in each cell?
please let me know how to do that, if it can be done.

thanks and regards

Daniel
 
P

Paul B

Daniel, you could use a helper column and put in this and fill down, then
copy and paste special over you data
="newword"&" "&A1

or with a macro

Sub Add_Word()
'will add newword in front of whats in the used range in column A
'Change to your range
Set rng = Intersect(Range("A:A"), ActiveSheet.UsedRange)
For Each c In rng
'change to the word you want to add
c.Value = "newword " & c
Next
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

Daniel

Excellent,

thanks for your help.

Daniel
Paul B said:
Daniel, you could use a helper column and put in this and fill down, then
copy and paste special over you data
="newword"&" "&A1

or with a macro

Sub Add_Word()
'will add newword in front of whats in the used range in column A
'Change to your range
Set rng = Intersect(Range("A:A"), ActiveSheet.UsedRange)
For Each c In rng
'change to the word you want to add
c.Value = "newword " & c
Next
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
Click to expand...
 
P

Paul B

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top