I would like to be able to search for a specific word, lets say "House" in a calc sheet, and then replace the entire cell content with something else like "Car".
It is important to notice, that the Find & Replace function does exactly this, but only with the word searched for, not with the entire cell contents.
So if I have a cell with the following content:
wefjweoi House dee88wef 4
I want to search for "House" find this cell, and replace the cell content with lets say the word "Car".
So the cell will look like this:
Car
Is this possible?
Best Answer
Just execute a
regex search
: In theFind & Replace
dialogue, openOther Options...
and enableRegular Expressions
. Then, in the search field, enter.*House.*
; replace withCar
. Now, since the regex pattern matches the whole cell content containingHouse
, the complete cell content is replaced byCar
.