I want to auto populate an excel drop down list based on parsing the first dash (-) of another drop down list
The first (column A) dropdown list contains values such as
AA - 1234
BB - 2345
CC - 1234
The second (column B) drop down list contains the values
I want to parse the pre-dash values from column A in order to auto-populate the column B drop down list.