Inserting a word

  • Thread starter Thread starter Daniel
  • Start date Start date
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
 
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
 
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...
 
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
 
Back
Top