repetitive added words

[Guest]

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]

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

 

[Guest]

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: