View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac
 
Posts: n/a
Default even spacing in a dropdown list.

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?