So I've been working with a spreadsheet that has a list of schools names. I pull data from this spreadsheet to create a roster that limits the size of text in each cell. In order to get the school names to fit, I have to remove the type of school from the name.
Example: Original name => Processed Name
- Generic Elementary => Generic
- Unnamed Middle School => Unnamed
- Across Town High School => Across Town
I can't look for the first space since some of the school names are two words long. I've been able to make this work with a highly nested IF statement.
The problem I have with this solution is that it is really long. What I would like is a way to have the FIND function search for more than one text string. I feel that would reduce this formula down to something much easier to read.
Does anyone have any ideas? Is there a more elegant way to do this?
Thanks in advance