excel image.jpg

Columns D, E & F are all formulated columns. I am trying to pull each word out of Column C. However, the state and the school do not have a space between them. I am wondering if there is a formula to pull the italicized word from the Column C or to insert a space infront of the italicized word. PLEASE HELP