Formula bar to show result - not formula?

[Absurdname]

When I create a formula linking to another cell, the formula works fine but when I select the cell to read the output in the formula bar, instead of seeing the text / result, I only see the formula.....my outputs are long free text comments which I'd like to be able to read in the formula bar, not in the cell...is this possible?

 

[Absurdname]

p.s. I don't want to 'copy and paste special' the values to another sheet / cell...

 

[Luke M]

In short, no. The formula bar does exactly as it's name implies, show the formula. You could either make the cell bigger to read it there, or hold Ctrl and press "[" to select the cell it is referencing (which would then let you read the text from that cell.