View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dnguyen411 dnguyen411 is offline
external usenet poster
 
Posts: 2
Default Taking contents of a cell an inserting them into a phrase.

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?