Data Validation List Character Limit Output

[Big_Dawg]

I have a list that I use in data validation in a range of cells. I want to use the list in the data validation but limit the output to the first 5 characters. How can I do this?

 

[Matty]

You could use a helper Column next to your list with a formula like:

=LEFT(A1,5)

And use this list for your Data Validation.

Matty