Forum Discussion
Extract Functions from a Formula
Hello, I often go to the Excel BI Challenges on linked in. I have started my own spreadsheet that I use as a reference. Anyway, what I do is take one of the formulas that has been given in the comm...
Hi willwonka,
I'm assuming your formula is in cell A2. In the empty cell, apply this formula:
=ARRAYTOTEXT(SORT(TOCOL(REGEXEXTRACT(FORMULATEXT(A2), "[A-Z0-9.]+(?=\()", 1))))This formula also considers cases when functions in Excel contain a point within them, such as the CEILING.MATH function or other functions of this type.
HTH
IlirU