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:

CURRENT	RESULTS WANTED
APPLES - HOLD 15	APPLES 15 / HOLD
ORANGES - HOLD 40	ORANGES 40 / HOLD
PINEAPPLE - HOLD 00	PINEAPPLE 00 / HOLD

<tbody>
</tbody>

 

[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....