Hello @Silver1964!
It is absolutely possible to find content in cells and replace them en-masse with other content. Most applications support this feature.
You can either click the "Find & Select" action in the "Editing" group of the "Home" ribbon, or use the CTRL+F keyboard shortcut. This brings up the "Find" dialogue.
The dialogue includes the "Replace" feature as well. I recommend expanding the advanced options using the "Options >>>" button to help you select the cells you want to search in and other options that may help in your specific case.
However, you will simply enter what you want to find in the "Find what" dropdown text field and type what you want the replacement to be in the "Replace with" dropdown text field.
Accepted Solutions
Hello @Silver1964!
It is absolutely possible to find content in cells and replace them en-masse with other content. Most applications support this feature.
You can either click the "Find & Select" action in the "Editing" group of the "Home" ribbon, or use the CTRL+F keyboard shortcut. This brings up the "Find" dialogue.
The dialogue includes the "Replace" feature as well. I recommend expanding the advanced options using the "Options >>>" button to help you select the cells you want to search in and other options that may help in your specific case.
However, you will simply enter what you want to find in the "Find what" dropdown text field and type what you want the replacement to be in the "Replace with" dropdown text field.