how can I replace strings in Google Sheets? I have a dropdown list with let's say apple, banana and I want to replace the word with another word depending on the selection in the dropdown list. Let's say if I choose apple in the list I want to replace the string with stone, if it's banana I want to replace it with car. How can I do that?
Aucun commentaire:
Enregistrer un commentaire