Move specific word to beginning of cell

Question

I have large spreadsheet that contains entries like:

Alabama Men's Sport Bracelet Team Color Dial

For each one I need to move the word Men's to the front of the text in the cell. Many of the cells contain the word Ladies rather than Men's but require the same operation.

Answer 1

A (marginally) shorter version than @rwilson's, but very similar:

=IFERROR(IF(SEARCH("Men's",A1),"Men's "&SUBSTITUTE(A1,"Men's ","")),IFERROR(IF(SEARCH("Ladies",A1),"Ladies "&SUBSTITUTE(A1,"Ladies ","")),A1))