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

"Daniel" <nospam@nowhere> wrote in message
news:(E-Mail Removed)...
> 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
>
>

Excellent,

thanks for your help.

Daniel
"Paul B" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "Daniel" <nospam@nowhere> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>>
>
>

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

"Daniel" <nospam@nowhere> wrote in message
news:O$(E-Mail Removed)...
> Excellent,
>
> thanks for your help.
>
> Daniel
> "Paul B" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> > "Daniel" <nospam@nowhere> wrote in message
> > news:(E-Mail Removed)...
> >> 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
> >>
> >>
> >
> >
>
>