The task is, find a function to convert any formula in excel into an
"atomic formula". Formally defined below, but first, an example:

Cell A1 is "=A2"
Cell A2 is "=A3+A4"
Cell A3 is "5" (atomic)
Cell A4 is "=A5+A6"
Cell A5 is "=7" (atomic)
Cell A6 is "=8" (atomic)

Then the function, given A1's formula "=A2' as input, would return
"=A3+A5+A6" as the equivalent atomic formula.


Define an "atomic cell" to be any cell containing no references to
other cells. An "atomic formula" contains only references to atomic
cells, not any other type of references. Every non-circular formula
can be reduced to an atomic formula by continually replacing the cell
references which are non-atomic with a statement of the formula itself,
as in the example

Does such a method exist, either built-in to excel or does someone have
code?

thanks