Solved

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

Posted on 2013-05-27
5
253 Views
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.
0
Comment
Question by:anthonymellorfca
5 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
Comment Utility
That feature is not available in excel.
0
 
LVL 39

Expert Comment

by:als315
Comment Utility
You can do following:
=23+10&"and some notes here"
0
 
LVL 9

Accepted Solution

by:
jsdray earned 250 total points
Comment Utility
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
 
LVL 9

Expert Comment

by:jsdray
Comment Utility
By the way.... N() is for Office 2013
0
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 250 total points
Comment Utility
jsdray,

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now