Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
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:
<tbody>
</tbody>
EXAMPLE:
CURRENT | RESULTS WANTED |
APPLES - HOLD 15 | APPLES 15 / HOLD |
ORANGES - HOLD 40 | ORANGES 40 / HOLD |
PINEAPPLE - HOLD 00 | PINEAPPLE 00 / HOLD |
<tbody>
</tbody>