[Solved] Find and replace advanced

[ger.wat]

I want to search for a term then replace everything in the cell it's in with another term.

How would I do that, is it even possible?

jerry

[RusselB]

I can't think of how you would do this, except for using the Find & Replace dialog (Ctrl+F) filling in the Find section, leaving the Replace section empty.
Use the Find button to go from one match to the next, and manually enter the new term. If the term is long, maybe put it into an unused cell, them just enter that cell address in the cells where you want the new term to be placed.
You can make changes to your spreadsheet without closing the Find & Replace dialog, but the dialog might go to the background when making the changes to your spreadsheet, especially if the spreadsheet is set for full screen/maximized.

[keme]

With regular expression enabled, replacing ".*<term>.*" with the other term should work.

Note that in the search term you would need to "escape" any character which is also a regex operator or special character. Example of characters needing special handling: Period, vertical bar, dollar sign, backslash.

[ger.wat]

...Use the Find button to go from one match to the next, and manually enter the new term. If the term is long, maybe put it into an unused cell, them just enter that cell address in the cells where you want the new term to be placed.
You can make changes to your spreadsheet without closing the Find & Replace dialog, but the dialog might go to the background when making the changes to your spreadsheet, especially if the spreadsheet is set for full screen/maximized.

This is quite helpful, I can work with this, thank you Russel.