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

[Guest]

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?

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com

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?

 

[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