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

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?

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

www.OfficeArticles.com
www.MyExpertsOnline.com



"RLP" wrote in message
...
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?

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


On Tue, 5 Jul 2005 11:20:02 -0700, RLP wrote:

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?