Ask Your Question

Partial auto replace within cell in calc

asked 2016-04-05 03:54:48 +0200

bsia546692 gravatar image

Hello All,

I am trying to find a way to automatically replace a certain section of text within a cell in calc.







For instance I have the following column above, every time there is an instance of "GenericText" I want it to be automatically replaced wth "fire". Similarly, every time there is an instance of "AlternateText" I would like it to be replaced with "water". But I would like the surrounding text to remain the same. Below is what I would like to achieve.







I have looked into the autocorrect options however it seems like autocorrect takes into account the whole cell's contents rather than just a certain section.

Any help would be much appreciated!

Regards, bsia546692

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-04-08 22:48:49 +0200

moshe11 gravatar image

updated 2016-04-08 22:50:46 +0200

Go to Edit--> Find & Replace .

Fill in the "Search For" and the "Replace With" text boxes , and press "Replace All" .

There might be problems if your text strings contain more than one word , or if they contain special symbols .

Try this , and let's hope for the best :)

Check these images of the before :

image description

And after the replacement :

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-05 03:54:48 +0200

Seen: 101 times

Last updated: Apr 08 '16