Move Text To End Of Cell

[Nanogirl21]

I have text in columns T, U, and V on a sheet called Tracking. In some of the cells I have “- Hold “. I would like to delete “- Hold “ and add “/ Hold“ to the end of the remaining text in the cell. Is there any way to do this using VBA? If not, what about a standard formula?

EXAMPLE:
[TABLE="width: 500"]
<tbody>[TR]
[TD]CURRENT
[/TD]
[TD]RESULTS WANTED
[/TD]
[/TR]
[TR]
[TD]APPLES - HOLD 15
[/TD]
[TD]APPLES 15 / HOLD
[/TD]
[/TR]
[TR]
[TD]ORANGES - HOLD 40
[/TD]
[TD]ORANGES 40 / HOLD
[/TD]
[/TR]
[TR]
[TD]PINEAPPLE - HOLD 00
[/TD]
[TD]PINEAPPLE 00 / HOLD
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jproffer]

I tried this code, but it is adding / HOLD to the end of every cell. I only want to add the / HOLD to the cells that contact - HOLD. Not all cells will have - HOLD.

Also, this code is cycling through each cell individually. My data is 15,330 rows and growing daily. Would take a super long time to move to each cell 1 by 1.

The formula you just said worked won't account for that. Just so you're aware....