Automatic replacement in Google Sheets
miklaf
Posted messages
4
Registration date
Status
Membre
Last intervention
-
miklaf Posted messages 4 Registration date Status Membre Last intervention -
miklaf Posted messages 4 Registration date Status Membre Last intervention -
Hello,
In Google Sheets, is it possible to replace a word, regardless of how it is written (uppercase/lowercase) with a version that has only one uppercase letter at the beginning? (The list of words is predefined)
For example: if I write TEST or test, it is automatically replaced by Test (after setting these words to be replaced)
In Excel, I was able to do this by adding the words to the dictionary (Options / proofing / AutoCorrect options):
I would ask it to replace test with Test, and it did so automatically.
Thank you for your help.
Configuration: Windows / Chrome 74.0.3729.108
In Google Sheets, is it possible to replace a word, regardless of how it is written (uppercase/lowercase) with a version that has only one uppercase letter at the beginning? (The list of words is predefined)
For example: if I write TEST or test, it is automatically replaced by Test (after setting these words to be replaced)
In Excel, I was able to do this by adding the words to the dictionary (Options / proofing / AutoCorrect options):
I would ask it to replace test with Test, and it did so automatically.
Thank you for your help.
Configuration: Windows / Chrome 74.0.3729.108
Let's imagine a table that I fill in every day, with the name of a person.
I want the name to appear as "Bernard," even if I sometimes write it as bernard, and this should be without using a formula.