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