Can multiple items be picked from a "list"?

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Example:
User has a list in a cell to pick from:

Apples
Oranges
Pears
Cherries
Monday
Tuesday
Wednesday
1st Quarter
2nd Quarter
3rd Quarter

I'd like them to pick 1 fruit name; 1 Weekday name; and 1
Quarter.

I'd like all these to be in the same cell separated by ;
because it's going to be exported back into Outlook as
categories.

Thanks.
sandy
(e-mail address removed)
 
It is going to take a lot of work to extract those words from a single cell,
but it can be done.

Why dont you spread it down a column?

At that point, I'm not sure what your question is..

Maybe you want to put a number by these, then the user enters a number in a
cell, and that item is returned somewhere else?
 
Hello Sandy,
Your write up is not clear, do you have four fruit names separated by
blanks then three weekdays separated by blanks, followed by thre
periods separated by blanks ,this all in one cell?
Do you want to pick any one fruit,any one weekday and any one tim
period?

The TEXT func6tions may do that for you by finding blank #1, blank #
that separate your items.
If this text is in cell A1 then:
FIND(" ",a1,1) will give you the first blank
The second blank can be computed if we know the first:
FIND(" ",a1,(FIND(" ",a1,1)+!))

Contact me if you have more questions.


Gabo
 
Back
Top