Is there a way with "Data Validation" where the data that shows on the drop down box, when selected, only displays the first five characters on the cell. For eg In a worksheet, List Range has got data validation settings whereby the value to be input in those cells comes from a list. The list looks something like this: "30000 Staff", "30010 Parking", "30020 Retail Store in Market St".
If I want to select for first selection from my the listbox - "30000 Staff" , what do I need to do to have only the value "30000" show up in output cell and not "30000 Staff". The reason I only need the numbers to show up is because that will in turn be used in another functions functions and save space instead of showing long information. The reason I am showing "staff, Parking, Retail" in my listbox is to give users additional information as a guidance to choose the correct code for those cells.
I tried to use Left formula but it didn't take List Range nor the dynamic name of a list; e.g. both of these didn't work;
=LEFT($AY$5:$AY$10,5)
=LEFT(Vendor_List,5)
If I want to select for first selection from my the listbox - "30000 Staff" , what do I need to do to have only the value "30000" show up in output cell and not "30000 Staff". The reason I only need the numbers to show up is because that will in turn be used in another functions functions and save space instead of showing long information. The reason I am showing "staff, Parking, Retail" in my listbox is to give users additional information as a guidance to choose the correct code for those cells.
I tried to use Left formula but it didn't take List Range nor the dynamic name of a list; e.g. both of these didn't work;
=LEFT($AY$5:$AY$10,5)
=LEFT(Vendor_List,5)
I may ended up with it if nothing works or can't find direct way. The hole point is to get ride of the explanation when you are done see what code you need to pick. So instead of showing;
