Adding text after formula or function

J

Joey

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

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."

.
Click to expand...
 
M

mzehr

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

example

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

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
 
M

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-----
Click to expand...
is that supposed to display? I tried it and I see 2.28,
the
 
D

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.
 
Top