Thread: Repetative text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smack smack is offline
external usenet poster
 
Posts: 13
Default 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