How to "rebuild" complex formulas?

Question

Spreadsheets

What and how do you do when you need to make changes to a complex formula with a lot of functions and nesting one into another? Are there any tricks, utilities, so that you can "rebuild" the formula? The idea of ​​simplification using additional cells is not considered.
Formula example:

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(MID(INDIRECT("RC[-3]";0);FIND("td";INDIRECT("RC[-3]";0);FIND("Текст:</td><td class=body>";
INDIRECT("RC[-3]";0);1))+18;FIND("/td";INDIRECT("RC[-3]";0);FIND("Текст:</td><td class=body>";
INDIRECT("RC[-3]";0);FIND("Текст:</td><td class=body>";INDIRECT("RC[-3]";0);1))+26)-FIND("td";
INDIRECT("RC[-3]";0);FIND("Текст:</td><td class=body>";INDIRECT("RC[-3]";0);1))-19);replace!A$2;
replace!B$2);replace!A$3;replace!B$3);replace!A$5;replace!B$5);replace!A$6;replace!B$6);replace!A$8;
replace!B$8);replace!A$9;replace!B$9))

Answer 1

Notepad++, brackets are also highlighted there.
Sometimes it's easier to decompose the formula into parts in different cells, make sure it works, and then - if necessary - "fold" it back, it's easier for large formulas + you can immediately see if it works or not.
If parts of the formula are used in several different complex formulas, it still makes sense to put them in separate cells that can be hidden \ placed outside the visible / printed areas \ put on another sheet, incl. hidden.

Answer 2

you can write a formula formation macro in VBA