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:

​

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]CURRENT
[/TD]
[TD="align: center"]WANT
[/TD]
[/TR]
[TR]
[TD]APPLES 10
[/TD]
[TD]APPLES 10
[/TD]
[/TR]
[TR]
[TD]PINEAPPLE / HOLD 2
[/TD]
[TD]PINEAPPLE 2 / HOLD
[/TD]
[/TR]
[TR]
[TD]BANANAS 20
[/TD]
[TD]BANANAS 20
[/TD]
[/TR]
[TR]
[TD]CHERRIES / HOLD 20
[/TD]
[TD]CHERRIES 20 / HOLD
[/TD]
[/TR]
[TR]
[TD]BANANAS / HOLD 82
[/TD]
[TD]BANANAS 82 / HOLD
[/TD]
[/TR]
[TR]
[TD]GRAPES 23 DON'T WASH
[/TD]
[TD]GRAPES 23
[/TD]
[/TR]
[TR]
[TD]GRAPES / HOLD 352 WASH
[/TD]
[TD]GRAPES 352 WASH / HOLD
[/TD]
[/TR]
</tbody>[/TABLE]


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.