I'm playing the game World of Warcraft and my guild has an attendance signup sheet for raids we do every week together. Everyone visits the sheet and types in their class|name|talents so that the rest of us know who will come to the raid and who won't.
I want the cells D9:F12, D16:F23, D27:F54, D58:F67, D71:F90 to automatically adjust to Proper case when someone types in a text in those cells.
so instead of:
I want it to look like this:
I am not good at scripts or Google Sheets in general... Please explain what I should do in an easy way so that I can understand the steps! Also, I am not interested in using addons. I believe this can be done by using a script.
It is important that the rest of the letters after the first letter in the word are lower case. Because there are charts that are counting how many classes are attending of each range. So if someone writes warrior instead of Warrior, that counts as 2 different inputs and it makes the chart show them both instead of just one.
I don't want to press some extra step (like a macro or keybind) to change the text, i want it all to be automated as soon as the users have made their text input to one of the cells within those ranges.
TLDR: I want the cells to automatically adjust the w to W. And the rest of the letters in each word to lower case.
Wrong input format:
Correct input format:
Is this possible? Thanks in advance!!!