Moving Text To End Of String?

[Nanogirl21]

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:

​

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.

 

[mikerickson]

You could use =SUBSITUTE(A1, " / HOLD", "") & " / HOLD"

 

[Nishant94]

Unknown
	A	B
1	CURRENT	WANT
2	APPLES 10	APPLES 10
3	PINEAPPLE / HOLD 2	PINEAPPLE 2 / HOLD
4	BANANAS 20	BANANAS 20
5	CHERRIES / HOLD 20	CHERRIES 20 / HOLD
6	BANANAS / HOLD 82	BANANAS 82 / HOLD
7	GRAPES 23 DON'T WASH	GRAPES 23 DON'T WASH
8	GRAPES / HOLD 352 WASH	GRAPES 352 WASH / HOLD
Sheet9

Cell Formulas
Range	Formula
B2	=IF(ISNUMBER(SEARCH("/ HOLD",A2)),SUBSTITUTE(A2,"/ HOLD","")&" / HOLD",A2)

 

[Nishant94]

Unknown
	A	B
1	CURRENT	WANT
2	APPLES 10	APPLES 10
3	PINEAPPLE / HOLD 2	PINEAPPLE 2 / HOLD
4	BANANAS 20	BANANAS 20
5	CHERRIES / HOLD 20	CHERRIES 20 / HOLD
6	BANANAS / HOLD 82	BANANAS 82 / HOLD
7	GRAPES 23 DON'T WASH	GRAPES 23 DON'T WASH
8	GRAPES / HOLD 352 WASH	GRAPES 352 WASH / HOLD
Sheet9

Cell Formulas
Range	Formula
B2	=IF(ISNUMBER(SEARCH("/ HOLD",A2)),SUBSTITUTE(A2,"/ HOLD","")&" / HOLD",A2)

 

[mikerickson]

I just noticed in the example given: "GRAPES 23 DONT WASH" >>> "GRAPES 23"

Is that a typo or do you want "DONT WASH" removed from every string?

 

[Nanogirl21]

Thank you for the help. Both of these worked as wanted.