I have a column which contains various formulas.
In the adjacent column to the right, I would like to document the cell formula on the left.
The 'document' cell format I like is: space followed by semi-colon followed by space followed by the cell's formula content on my left.
I can cut and paste the cell formula into a text string which is OK.
But if new rows are added or inserted, the formula's column content will adjust whereas the text documentation alongside doesn't.
So, is there a simple way say, of using a 'documenting' formula to do what I want?
Any help much appreciated!