Find and replace fields by sheet

[tinkerz1]

Hi,

Ok its time to ask this simple question, if I want to find and replace fields in an expression and/or dimension for a whole sheet, how can I do it?

Thanks,

Neil

[awhitfield]

Hi Neil,

you can you find and replace in the EXPRESSION OVERVIEW, Ctlr+Alt+e

Andy

[stigchel · Accepted solution]

In the settings\expression overview, sort on sheetname by clicking on the header, select all expressions and do a replace in selection.

[Anonymous]

i think this is the correct solution...found new thing today

[stigchel]

Hi Neil,

If any of this has answered your question, could you please mark the relevant answer as correct (and/or helpfull)?

Marking answers correct will close the thread, help others finding correct answers for similar problems and let other contributing members know this requires no more attention.

Thanks,

Piet Hein