Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 331
- Office Version
- 365
- Platform
- Windows
Is there a formula to move a specific text within a cell to the end of the string?
For all rows in column W I would like to move “ / HOLD” to the end of the sting. If the cell does not have “ / HOLD” I would like to keep it as is.
I would like the results to be in column X.
Example:
<tbody>
</tbody>
Thank you for the help.
For all rows in column W I would like to move “ / HOLD” to the end of the sting. If the cell does not have “ / HOLD” I would like to keep it as is.
I would like the results to be in column X.
Example:
CURRENT | WANT |
APPLES 10 | APPLES 10 |
PINEAPPLE / HOLD 2 | PINEAPPLE 2 / HOLD |
BANANAS 20 | BANANAS 20 |
CHERRIES / HOLD 20 | CHERRIES 20 / HOLD |
BANANAS / HOLD 82 | BANANAS 82 / HOLD |
GRAPES 23 DON'T WASH | GRAPES 23 |
GRAPES / HOLD 352 WASH | GRAPES 352 WASH / HOLD |
<tbody>
</tbody>
Thank you for the help.