Adding text after formula or function

[Joey]

Is there a way to add text after a formula or function in
a cell. Maybe to reference something.

 

[Guest]

Thanks I'll give it a try!

-----Original Message-----
add an ampersand(&) and the text in quotations

for example: ="Total is: " &sum(a1:a15)
=sum(a1:a15)&" is the total."

.

 

[mzehr]

Hi Joey
try using the following +N("") after your formula

example

= 57/25 + N("Your Text Goes Here")
HTH

 

[dderolph]

try using the following +N("") after your formula How is that supposed to display? I tried it and I see 2.28, th
calculation of 57/28, nothing else. So, what's to be gained b
attaching + N("Your Text Goes Here") to the forumula

 

[mzehr]

Hi dderolph,

That text doesn't display. It is one way to attatch a
comment after a formula for reference only, rather than
using an external comment box.

-----Original Message-----

is that supposed to display? I tried it and I see 2.28,
the

 

[dderolph]

I see what you mean now. Thanks. I thinks I'd rather use a Comment in
most cases because the little Comment marker in the cell makes the
notation more visible. Probably a matter of habit, also.