Taking contents of a cell an inserting them into a phrase.

[dnguyen411]

I'm creating a lookup table in Excel that list certain pieces of text I want
to add in a phrase. For example, let's say in Cells A1 - C1 I had "Mary",
"lamb", "snow."

In Cell D1, I want to write a phrase that will grab the contents of Cells A1
- C1 to form a sentance. In this example: "A1" had a little "B1", whose
fleece was white as "C1"

So when I hit enter, the phrase will come out: Mary had a little lamb whose
fleece was white as snow.

Does anybody know how to do this without resorting to using multiple cells
in a row?

 

[Debra Dalgleish]

You can combine the cell references with text strings:

=A1 & " had a little " & B1 & ", whose fleece was white as " & C1