There are several issues to address here so let's cover them individually.
The date formatting from number ranges. One way is to retain some common preceding text such as "Range:". If this is not possible then we can add some replacement pairs from 1 to 9 with adding an apostrophe to stop Excel converting the text to a date.
Extra spaces. We can remove multiple spaces by using replacement pairs specifying a double space to be found and a single space to be the replacement.
The name of the school. Sometimes we can get the initial text in a row by specifying a common text which occurs at the end of the row above. Sometimes this can be further above with wildcard replacement pairs to remove everything in between. Text formatting is irrelevant as the conversion creates plain text before being interrogated.
Personnel. It is usually best to first extract as much text as needed and then clean using rules defined in the replacement pairs. Sometimes we need to be quite creative here.
