SOLVED

Drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2477967%22%20slang%3D%22en-US%22%3EDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2477967%22%20slang%3D%22en-US%22%3ENot%20sure%20this%20is%20possible%20but%20here%20we%20go.%20So%20I'm%20wondering%20if%20there%20is%20a%20way%20for%20my%20drop%20down%20list%20to%20reflect%20how%20I%20have%20my%20data%20formatted%20for%20that%20drop%20down%20list.%20So%20if%20I%20have%20a%20name%20in%20bold%20with%20parenthesis%20(steven)%20it%20will%20show%20like%20that%20on%20my%20drop%20down%20list%20and%20when%20selected%20it%20will%20transfer%20like%20that%20in%20the%20specified%20cell.%20Not%20sure%20if%20there%20is%20a%20formula%20for%20that%20or%20if%20it%20needs%20to%20be%20a%20macro%20or%20VBA.%20thanks%20for%20the%20help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2477967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2478173%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2478173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F289214%22%20target%3D%22_blank%22%3E%40spalmer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20Excel%20doesn't%20support%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor
Not sure this is possible but here we go. So I'm wondering if there is a way for my drop down list to reflect how I have my data formatted for that drop down list. So if I have a name in bold with parenthesis (steven) it will show like that on my drop down list and when selected it will transfer like that in the specified cell. Not sure if there is a formula for that or if it needs to be a macro or VBA. thanks for the help
2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@spalmer 

Sorry, Excel doesn't support that.

Ya I didn't think so. Hopefully one day they will though. Thank you Hans! I appreciate it