Adding a comment to a formula-not a cell

F

Floridagal

I just went brain dead and can't remember the keystroke to
add a comment to a formula, not the cell.

Please help!

TIA
 
G

Gord Dibben

Use the N

=a2*a1+N("my wage+bonus-4 weekly loan repayments")


Gord Dibben Excel MVP
 
D

Dave Peterson

And if you're working with text:

=A1&B1&"hi there"&TEXT("this is a comment",";;;")
 
Top