I have four footnotes to a report that each include a calculation and text, I thought I found a solution until I needed to enter in my fourth footnote.
Using the Char() formula, I have thus far been able to achieve having a superscript number, so far 1,2, and 3, and then text and formula as a complete footnote. Char(185)=1, Char(178)=2, Char(179)=3, but what is 4 and so on? Char(???)=4?
Now I need a fourth footnote, and my Char() does not work. I am slowly realizing that the Char() may only have a couple hundred variables, and the code I have for 4 is 8308, Char(8308) refs out.
I cannot add a seperate column, this all needs to be in one cell, and I need to have the sueprscript, followed by some text, followed by a formula (A1-A2), followed by further text.
Thank you for your help.
Using the Char() formula, I have thus far been able to achieve having a superscript number, so far 1,2, and 3, and then text and formula as a complete footnote. Char(185)=1, Char(178)=2, Char(179)=3, but what is 4 and so on? Char(???)=4?
Now I need a fourth footnote, and my Char() does not work. I am slowly realizing that the Char() may only have a couple hundred variables, and the code I have for 4 is 8308, Char(8308) refs out.
I cannot add a seperate column, this all needs to be in one cell, and I need to have the sueprscript, followed by some text, followed by a formula (A1-A2), followed by further text.
Thank you for your help.