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