No, you really don't want all the answers in one cell.
But might I suggest trying an AutoFilter. To learn more,
see:
http://www.contextures.com/xlautofilter01.html
HTH
Jason
Atlanta, GA
-----Original Message-----
Hey,
I would like a formula whereby I can string together
text strings in an
excel database together
i.e. I have two columns, "question number"
and "answer"... and a long list
of entries (each question number coming up several times
with different
answers)
Now I want to have all the answers for question 8 as a
text string in a new
cell...
How do I do it?
Would appreciate a quick answer... thanks
.