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

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?

Hi Brian,

=A1+B1&" Is the result of adding A1 & B1"

--
Kind regards,

Niek Otten

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

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

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

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.
--
Gary's Student


"Brian" wrote:

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?

Hi!

Try this:

=your_formula_here&" your_text_here"

Biff

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

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)


--
widemonk


------------------------------------------------------------------------
widemonk's Profile: http://www.excelforum.com/member.php...o&userid=20402
View this thread: http://www.excelforum.com/showthread...hreadid=475560

... and brian is a guest so he wont see my reply :rolleyes:


--
widemonk


------------------------------------------------------------------------
widemonk's Profile: http://www.excelforum.com/member.php...o&userid=20402
View this thread: http://www.excelforum.com/showthread...hreadid=475560