Can you post your data how it looks. From your above pasted data, it is not clear if you have 4 rows or 1.
Can't post real data, private and too many rows. But to answer your question it is 4 rows. Just wanting to show the variety of data in rows. Not a simple parse.
IF FIND(RIGHT(TRIM([Site]),5),' ') > 0 //If there is a space in the last five characters,
THEN SPLIT(TRIM(REPLACE(REPLACE([Site],')',''),'(',' ')),' ',-2) + ' ' //the include 2nd-to-last word
+ SPLIT(TRIM(REPLACE(REPLACE([Site],')',''),'(',' ')),' ',-1) //and also include the last word
It works for the four examples given; hopefully it also handles most of your actual site names.