Repetative text
Thank you so much, great help!!!
"Roger Govier" wrote:
Hi Sue
Assuming the data is contiguous in the 200 rows, and assuming column A
for this example
In cell B1
=IF(A1="","",A1&" RS")
copy down through B2:B200
Copy column B
Paste SpecialValues back over column A
Delete column B.
--
Regards
Roger Govier
"smack" wrote in message
...
Hi All,
I have approximately 200 rows of data and would like to add "RS" to
the end
of each instruction example:
NOW;
Adjust nuts and bolts
WOULD like it to read;
Adjust nuts and bolts RS
Any suggestions are appreciated,
Sue
|