Chris,

The only thing that comes to mind is using 2 columns.

The first has your validation and should be wide enough to see what you
want. Say this is column A. In column B, starting with (say) B1 use
=Left(A1,7)
Than fill the formula down.

--
sb
"Chris" wrote in message
...
Is there code to accomplishe the following?

I have combined two columns into one so that a Data,
Validation List will show a Job Number and Job Name. Upon
picking from the list, I only want the first 7 characters
to be entered.

Secondly, Is there a way to expand the size of the drop
down list that is coming from the Data, Validation List,
to see the entire cell contents.

If so which event would be code be placed in?

Thanks
Chris