Can multiple items be picked from a "list"?

[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)

 

[Dave R.]

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?

 

[Jason Morin]

I'd use a listbox. Check out:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;829070&Product=xl2002

HTH
Jason
Atlanta, GA

 

[Gabor Sebo]

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

 

[Dave R.]

Finding spaces is the easy part, even with the extra parentheses.

To yank the words out is something else, see
http://www.cpearson.com/excel/excelF.htm#Words

 

[Sandy]

Thanks to all of you.

sandy