Hello all,

I have a list of 250+ schools and want to create a variable that takes the first letter from each word in the school name string.

For example:

If a school is named Lady Irwin School, I'd want to keep just LIS. If a school is named Cama Road English Primary School, I'd want to keep CREPS.

How should I go about doing this?

Thank you in advance!