0

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:

warrior|huzzah|fury

I want it to look like this:

Warrior|Huzzah|Fury

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:

wArRiOr|HUZZAH|fury

Correct input format:

Warrior|Huzzah|Fury

//

Is this possible? Thanks in advance!!!

  • There's a built-in function for that : =Proper() if you can reprocess the inputs. – pjmg Nov 2 at 9:18
  • @pjmg I am aware that this function exists. But I don't know how to use it to replace a users text input in the same cell without creating a new cell with that function, which is not what I want. I want it to adjust the text in the same cell as the user has used to write the words on, not adding one more cell to write it again. – Volux Nov 2 at 10:00
  • Ok sorry I tried to be non technical because some folks are. Did you already saw this ? stackoverflow.com/a/11334512 to get the range + webapps.stackexchange.com/a/33373/222777 to capture when a cell is edited – pjmg Nov 2 at 11:34
  • Have you already read developers.google.com/apps-script/guides/sheets? – Rubén Nov 2 at 15:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.