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