Can you have a formula followed by text all in one cell?

B

Brian

Just as the subject askes, I what to have a formula in a cell that the number
that it puts out is then followed by whatever text i want. Is this possible?
 
P

Paul B

Brian, here is on way,

=A1&" Your text here"
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
G

Gary''s Student

Yes.

Select the cell with the formula in it and pull_down:
Format > Cells... > Number > Custom
the Type-in field will say General
Your enter General" hello world"
and you will see the result. If you do it this way you can still use the
cell for math.
 
W

widemonk

you might need to explain a little more what you're trying to acheive.

There are two ways, either:

=[formula]&"text"

or

=[formula]&D4 (where cell D4 contains the text you want adding to the
end)
 
Top