repetitive added words
 

I have a spreadsheet with colums one with number and second with alphabetic
list . Now i wanted to add the same word RR3 to the right end of each row of
the second colum. I know we can create macro but i don't seem to succeed
doing it in excel it is my first time macro in excel they do not work like in
Word.Thanks
17 - BARA BRAES FARMS (OCT)
RR3
16 - BARBER, John, Gloria, Patrick (JULY)
17 - BARAGAR, Allen, Gordon, Willogene, Kathy (OCT)

--
XP home , Office 97

any or all responses are gratefully accepted and thank you for your time

Running Compaq P3, 500Mhz
WIN XP home, Office XP SB
Dialup (no choice here)

How about just inserting a column to the right of that second column.

Then you can use a formula like:

=B2&"RR3"
or
=B2&" RR3"

Drag down your column.
select that column
edit|copy, edit|paste special|values over the original column
and delete the helper column

justamailman wrote:

I have a spreadsheet with colums one with number and second with alphabetic
list . Now i wanted to add the same word RR3 to the right end of each row of
the second colum. I know we can create macro but i don't seem to succeed
doing it in excel it is my first time macro in excel they do not work like in
Word.Thanks
17 - BARA BRAES FARMS (OCT)
RR3
16 - BARBER, John, Gloria, Patrick (JULY)
17 - BARAGAR, Allen, Gordon, Willogene, Kathy (OCT)

--
XP home , Office 97

any or all responses are gratefully accepted and thank you for your time

Running Compaq P3, 500Mhz
WIN XP home, Office XP SB
Dialup (no choice here)

--

Dave Peterson

sub addtext()
For i = 1 To rowcount
Range("B" & i).Value = Range("B" & i) & "RR3"
Next i
end sub

Give variable rowcount a value representing the number of your rows!

Regards,
Stefi

€žjustamailman€� ezt Ã*rta:

I have a spreadsheet with colums one with number and second with alphabetic
list . Now i wanted to add the same word RR3 to the right end of each row of
the second colum. I know we can create macro but i don't seem to succeed
doing it in excel it is my first time macro in excel they do not work like in
Word.Thanks
17 - BARA BRAES FARMS (OCT)
RR3
16 - BARBER, John, Gloria, Patrick (JULY)
17 - BARAGAR, Allen, Gordon, Willogene, Kathy (OCT)

--
XP home , Office 97

any or all responses are gratefully accepted and thank you for your time

Running Compaq P3, 500Mhz
WIN XP home, Office XP SB
Dialup (no choice here)