In cell value AND notes e.g." 12.50 and some notes here "

I'm looking for a Lotus 123 equivalent feature in Excel.

In 123 I could enter into a cell:

+23+10;and some notes here

and the cell would evaluate to a value of 33, and the notes would be in view in the edit box when one selected the cell.

(The Excel cell note feature is not what I am looking for, wonderful though it is.)

thanks for your interest.
LVL 9
Anthony MellorChartered AccountantAsked:
Who is Participating?
 
jsdrayConnect With a Mentor Commented:
The N() function allows you add comments directly inside your cells on your formulas. To use the function to add a comment, simply add a plus sign (+) to the end of your formula, and then enter some text in quotes inside the parentheses, passing that text to the N() function.
0
 
Saqib Husain, SyedEngineerCommented:
That feature is not available in excel.
0
 
als315Commented:
You can do following:
=23+10&"and some notes here"
0
 
jsdrayCommented:
By the way.... N() is for Office 2013
0
 
NBVCConnect With a Mentor Commented:
jsdray,

N() is the correct/best way to do this task... and it is available in previous versions also, not just 2013
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.