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?
protect the formulas with the GUARD function. Otherwise split wisely the parts that feed the formulas, so a replacement gets easier.
Thanks, GUARD was perfect.