even spacing in a dropdown list.

M

Mac

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?
 
M

Mallycat

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

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

Create a formula that determines the maximum number of characters i
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))

Mat
 
Top