I would like to put a formula into a sentance, the sentance is not allows the
same so I can not have it in two cells and print it the way I want it to.

(Example: The color of my car is red.)
What I would like to be able to do is have the word "red" equal another cell.

The color if my car is [=A1].
All of this would still be in one cell.

="The color of my car is "&A1
use the Ampersand (&) to combine
Hope this helps.
--
John C


"Stacey" wrote:

I would like to put a formula into a sentance, the sentance is not allows the
same so I can not have it in two cells and print it the way I want it to.

(Example: The color of my car is red.)
What I would like to be able to do is have the word "red" equal another cell.

The color if my car is [=A1].
All of this would still be in one cell.

Stacey,

Try

="The colour of my car is " & A1

Mike

"Stacey" wrote:

I would like to put a formula into a sentance, the sentance is not allows the
same so I can not have it in two cells and print it the way I want it to.

(Example: The color of my car is red.)
What I would like to be able to do is have the word "red" equal another cell.

The color if my car is [=A1].
All of this would still be in one cell.

="the color of my car is " & INDIRECT("A1")


Gord Dibben MS Excel MVP

On Wed, 15 Oct 2008 08:50:00 -0700, Stacey
wrote:

I would like to put a formula into a sentance, the sentance is not allows the
same so I can not have it in two cells and print it the way I want it to.

(Example: The color of my car is red.)
What I would like to be able to do is have the word "red" equal another cell.

The color if my car is [=A1].
All of this would still be in one cell.