Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text formula
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
If you'll use the same form again, you can form a worksheet with formulas,
then pastin' the answers will be enough to make answers be grouped A B C D Question No: Answer: 1. answer.1 =(IF(A1=1;b1;"") =concatenate(b1;b2;....;b12) 2. answer.2 =(IF(A2=1;b2;"") 3 answer.3 .... 1 answer.4 .... 2 answer.5 .... 3 answer.6 .... 1 answer.7 2 answer.8 3 answer.9 1 answer.10 2 answer.11 3 answer.12 it's enough to write formula in one cell, then pullin' the "+" will copy the formula to selected cells with this manner it won't take more than 2 min' to prepare the whole worksheet (this example is only for question no.1) attention: concatenate function works up to 30 cells, if more than 30answers, use more concatenate "c_prenderville" wrote in 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding text to the result of a formula? | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
formula is displaying as text rather than result. | Excel Worksheet Functions |