Ask Your Question
0

Partial auto replace within cell in calc

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

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.

(01)GenericText(02)XYZ

(01)GenericText(02)123

(01)GenericText(02)ABC

(01)AlternateText(02)XYZ

(01)AlternateText(02)123

(01)AlternateText(02)ABC

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.

(01)Fire(02)XYZ

(01)Fire(02)123

(01)Fire(02)ABC

(01)Water(02)XYZ

(01)Water(02)123

(01)Water(02)ABC

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
0

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

moshe11 gravatar image

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

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

Stats

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

Seen: 66 times

Last updated: Apr 08 '16