Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
How do I change a word that appears 37 times in my sheet? Ctrl H, does not work. thanks
Here is what we do:
Filter for the word, copy and paste the text into a text editor, use find+replace, paste it back in.
If you are replacing the entirety of the cell, then you can simply skip the use of the external program. Selecting and pasting over a range of cells which are filtered will only modify the data which is visible, and not the data which is behind the filter.
I am happy to announce we have added a find and replace feature to Smartsheet! Read my announcement here: https://community.smartsheet.com/announcement/new-smartsheet-find-and-replace-within-sheet-and-identify-web-form-responses
