Repetative text
 

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

Repetative text
 

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:

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

Repetative text
 

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

Repetative text
 

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


"smack" skrev:

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

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