Can you paste some samples of the mixed data that's returned by your DV in
col B?
There could be a formula way to extract the required account name into
another adjacent col, eg col C. But I don't think you can do it directly in
the DV itself other than through code such as Debra's
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Klee" wrote in message
...
Thanks, is there a way to do it without having to use code?

I tried to set up my worksheets exactly like the one in the example you
pointed me too and I copied the code to my worksheet but it didn't do
anything.Beyond cutting and pasting I have no idea how to use code.

I also tried to use a formula in the data validation screen for the drop
down list - =left(acctlist,9) becausemy account numbers are nine digits
long
but it gives me a warning saying that it results in an error.

Thanks for your help