I need to clean up the placement of a specific 4-character acronym ("XXXX") in a large spreadsheet. Specifically, all instances of "XXXX" that occur at the beginning of a string only need to be moved to the last place in the string, preceded by a single space, and any extra spaces, dashes remaining at the beginning of the string after "XXXX" is moved is to be removed so that the row starts with the first complete word in that row. Any instances of "XXXX" that occur in any other position in the string except at the beginning are to be ignored.
Various examples of current format (does not include all possibilities):
1. XXXX - CITY TYPE
3. XXXX-CITY-TYPE PROCEDURE HERE
1. CITY TYPE XXXX
2. CITY XXXX
3. CITY-TYPE PROCEDURE HERE XXXX