Search and Replace

[AnotherNoOne]

Hi,
following problem:

I use Shapes with Text fields that include Shape Data as Text. (linked via formulas)
When I use search and replace to replace a PART of the text, it removes everything instead.
My theory:
When confronted with Shape Data Links in a text field the search and replace function cant change the Shape Data wich is shown and then replaces the entire Shape Data Link instead.

Anyone got a clever idea how to work around this problem?

[Yacine]

protect the formulas with the GUARD function. Otherwise split wisely the parts that feed the formulas, so a replacement gets easier.

[AnotherNoOne]

Thanks, GUARD was perfect.