Showing Text in Formula Bar not Formula

[karmaimages]

Hi

I don't know if this is possible at all, I couldn't seem to find the answer.

I'm building a dashboard which looks up some information from another sheet (hidden) using a VLOOKUP - I'm going to hide the formulas once I've finished, however I want the text of the information pulled using the VLOOKUP to show rather than the formula bar showing blank or the formula, is this possible.

Some of the text it pulls is quite lengthy and I don't want to word wrap the cell as this changes the design of the rest of the spreadsheet.

 

[JoeMo]

The cell the formula is in shows the text. The formula bar shows the formula. To have the text appear in the formula bar you would have to overwrite the formula.