Move one word from a cell and put it in an adjacent cell

Closed
Vanessa - Aug 19, 2016 at 04:12 PM
Hello,
Hi what is the formula to move anything that begins with "other: " to the adjacent cell

Advocate at Home
Advocate at Home
Other: Bria of Palos Hills
Lexington - Chicago Ridge