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

Posted on 2013-05-27
Medium Priority
Last Modified: 2013-05-28
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.
Question by:Anthony Mellor
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39199187
That feature is not available in excel.
LVL 41

Expert Comment

ID: 39199192
You can do following:
=23+10&"and some notes here"

Accepted Solution

jsdray earned 1000 total points
ID: 39199193
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.

Expert Comment

ID: 39199200
By the way.... N() is for Office 2013
LVL 23

Assisted Solution

NBVC earned 1000 total points
ID: 39199226

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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question