Question: how to get value from dropdown in excel?
Answer: Go to Data tab, click Data Validation, go to Settings tab, copy Source. Paste into Word to remove commas and put into multiple lines. Then paste back into Excel.