Help with data validation

Hi, there is a problem with data validation and the given data. When I have data that contains space between symbols, for example (BBA 4), when constructing a list in data validation and using a func...