Excel formula to move a word from one cell to another

vfelts Posts 2 Registration date Friday August 19, 2016 Status Member Last seen August 19, 2016 - Aug 19, 2016 at 04:15 PM
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