List using Data Validation

  • Thread starter Thread starter Jim Patton
  • Start date Start date
J

Jim Patton

I have a list that I created using teh DATA, VALIDATION,
LIST, LISTNAME.
Is there a way that after an item is selected form the
list that it will only show the first 3 characters?
I tried putting the following in the source but not
working.
SOURCE- =LISTNAME+LEFT(CELL,3)
NO GO...

Any ideas?
 
One way is to just set the column width to only show the first three
characters of the string and put just a "space" in the cell to the right to
prevent overflow.........

Vaya con Dios,
Chuck, CABGx3
 
If the first three characters your're talking about are numbers, you can
just put them in your validation list cell, and complete the rest of the
selection in a custom format such as ### "the rest of the selection"
.......this will show up in the list as "123 the rest of the selection" but
only the 123 will come through on the validation feature......

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top