We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

Partial auto replace within cell in calc [closed]

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

bsia546692 gravatar image

updated 2020-08-16 12:38:55 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-20 09:08:01.669264

1 Answer

Sort by » oldest newest most voted
0

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

Question Tools

1 follower

Stats

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

Seen: 196 times

Last updated: Apr 08 '16