How do you use text in a formula so it will calc, but ignores txt

R

RLP

I thought there use to be a way to put text/info/label next to a number in a
formula that would still let it calculate but just ignore the text? In other
words, just in a simple formula like 2+3, you could type text next to each
number and the cell would still say 5?
I'm working with XP right now and maybe that feature does not exist anymore?
 
A

Anne Troy

You could do a custom format, such as "abc-"0
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



RLP said:
I thought there use to be a way to put text/info/label next to a number in a
formula that would still let it calculate but just ignore the text? In other
words, just in a simple formula like 2+3, you could type text next to each
number and the cell would still say 5?
I'm working with XP right now and maybe that feature does not exist
Click to expand...
anymore?
 
G

Gord Dibben

RLP

Try this....

=2+3+n("my wage+bonus-4 weekly loan repayments")

You will see the text in the formula bar but not in the cell.

The cell will calculate to 5 as you wish.

Note: you can also use cell references as in

=A2*A1+N("my wage+bonus-4 weekly loan repayments")

You could alternatively use a cell Comment to display the text.


Gord Dibben Excel MVP
 
Top