Repetative text

S

smack

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
 
E

excelent

Select ur cells and run macro

Sub myAdd()
For Each c In Selection
If c.Value <> "" Then c.Value = c.Value & " RS"
Next
End Sub



"smack" skrev:
 
R

Roger Govier

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 Special>Values back over column A
Delete column B.
 
E

excelent

or in a second column use a formula like
=A1&" RS"
and copy down - if u have ur data in column A


"smack" skrev:
 
S

smack

Thank you so much, great help!!!


Roger Govier said:
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 Special>Values back over column A
Delete column B.
Click to expand...
 
Top