Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Convert comma separated string to DropDown
I have one cell which has string "jingo,bingo,tango,mango". In another
cell I want to create drop down list which has jingo, bingo etc as separate values in the list. Also I dont want to use macros. Is it possible to create such list just by using available excel functions and Data Validation dialog box? |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Convert comma separated string to DropDown
Hi
AFAIK this is not possible without macros "ssuyog" wrote: I have one cell which has string "jingo,bingo,tango,mango". In another cell I want to create drop down list which has jingo, bingo etc as separate values in the list. Also I dont want to use macros. Is it possible to create such list just by using available excel functions and Data Validation dialog box? |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Convert comma separated string to DropDown
Why don't you just copy the cell contents as a single string and then paste it
into the box in the Data Validation list when you choose List. As long as your data is comma delimited then it will appear as a vertical list with each value separately available as a choice. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "ssuyog" wrote in message om... I have one cell which has string "jingo,bingo,tango,mango". In another cell I want to create drop down list which has jingo, bingo etc as separate values in the list. Also I dont want to use macros. Is it possible to create such list just by using available excel functions and Data Validation dialog box? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.797 / Virus Database: 541 - Release Date: 15/11/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text string separated by comma | Excel Discussion (Misc queries) | |||
How do I convert a column of numbers into comma separated values . | Excel Worksheet Functions | |||
Divide comma-separated string and look up corresponding category | Excel Programming | |||
Divide comma-separated string and look up corresponding category | Excel Programming | |||
Divide comma-separated string and look up corresponding category | Excel Programming |