Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the text results of a survey in just one cell stored as text, I would
like to generate the required number of columns as per the answers given, for example : In Cell J1 I have : Easier:no,Faster:no,More Plaisant:no,The original system with the white boards was easier; faster; and anybody could look at them and tell what was going on. I would like to extract the information and generate the columns K (Easier), L (Faster), M (More Plaisant), N (comments) with the answers on each column (no, no, no, "The original ...), what should be the code ? Thanks in advance -- Moises |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting certain text from text string | Excel Worksheet Functions | |||
Extracting h:mm:ss from text string | Excel Worksheet Functions | |||
Extracting text from string | Excel Worksheet Functions | |||
Extracting text from text string | Excel Worksheet Functions | |||
Extracting Text in a string of text | Excel Discussion (Misc queries) |