Use a combo box from the control toolbox and use a fixed width font like
Courier.

Biff

"Squeaky" wrote in message
...
I have two columns of cells I have joined together with the &. This 3rd
column is then displayed on a second page using a drop down combo box from
the forms menu. Since the information in each row is a different length is
there any way to make the drop down box display the information as such:

Chevrolet Cobalt
Ford Areostar
Mazda Miata
Toyota Tundra

Where the second column is aligned as well as the first? I need to be able
to do this with a formula if possible since there are over a thousand
entries. I tried adding 20 blanks or underscores to the first column,
trimming it, then adding to the 2nd column, but the varying widths of each
letter still made it look crooked.

Thanks,

Squeaky