I understand how to make a drop down listusing the formula below:
=(A1&" "&B1&" ETC.....

What I am asking is there something I can input in the formula to make the
space the same between the cells even though the characters in each row of
cells is different?

Not really sure what you are trying to do. I don't see the link between
drop down lists and your formula

To answer your question, the only thing you can really do is pad the
formula with extra spaces. You would need to do the following

Create a formula that determines the maximum number of characters in
the text ie in cell D1 put
=MAX(LEN(A1),LEN(B1),LEN(C1))

Then use this formula
=A1&REPT(" ",D1+1-LEN(A1))&B1&REPT(" ",D1+1-LEN(B1))&C1&REPT("
",D1+1-LEN(C1))

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555161