Listing the function names used in a formula?

[PP3321]

I need to explain to my colleagues how my formulas work.
I want to list the functions used in a formula automatically in the rows below.

For example:

'=IFERROR(SUM(A1:A3),"")
↓↓↓↓↓↓↓↓↓
IFERROR
SUM


I thought of 2 solutions but I am stuck there.

1. <Mid & Search>
I tried to find pattern by looking at opening bracket.
"*("
But this does not work because some formulas contain two brackets consecutively.
"(("

2. <table>
Another solution I thought of is to create a table with the function names.
Then I can search the list within the formula string.

Could you please give me some clues how I should approach this problem?

 

[shrivallabha]

Formula solution with (2nd option) table would be easier in my opinion. You can pick basic list by searching online e.g.
http://www.techonthenet.com/excel/formulas/
Here the ones identified as WS are used in worksheet.

Once done, you can use formula which will list out the functions in formula string.

 

[NARAYANK991]

Hi ,

You might find this useful :

https://sites.google.com/site/e90e50/random-topics/tool-for-parsing-formulas-in-excel

Narayan

 

[PP3321]

Thank you all for your answers!!!!!!!