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

Brian · 10-12-2005, 03:05 PM

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?

**widemonk** · 10-12-2005, 03:34 PM

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** · 10-12-2005, 03:35 PM

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

Niek Otten · 10-12-2005, 04:05 PM

Hi Brian,

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

--
Kind regards,

Niek Otten

"Brian" <Brian@discussions.microsoft.com> wrote in message
news:9F7DC8A6-1A64-4FDE-8A53-FE416865327A@microsoft.com...
> 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?

Paul B · 10-12-2005, 04:05 PM

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" <Brian@discussions.microsoft.com> wrote in message
news:9F7DC8A6-1A64-4FDE-8A53-FE416865327A@microsoft.com...
> 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?

Gary''s Student · 10-12-2005, 04:05 PM

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?

Biff · 10-12-2005, 04:05 PM

Hi!

Try this:

=your_formula_here&" your_text_here"

Biff

"Brian" <Brian@discussions.microsoft.com> wrote in message
news:9F7DC8A6-1A64-4FDE-8A53-FE416865327A@microsoft.com...
> 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?