align 3 concatenated strings for column appearnace
 

I combined 3 cells to make a drop down list. However I am not pleased with
the final appearance as the texts scrawls over the page. I'd like to align
the text strings so that its appearance is more appealing while still using
the drop down lists. Thanks for your help.

align 3 concatenated strings for column appearnace
 

"Dano" wrote
I combined 3 cells to make a drop down list.
However I am not pleased with
the final appearance as the texts scrawls over the page.
I'd like to align the text strings
so that its appearance is more appealing
while still using the drop down lists.

Not sure.. we could add line breaks
via using CHAR(10) in the concat formula, eg:

In D1: =A1&CHAR(10)&B1&CHAR(10)&C1

But the DV's destination cells
would still need to be formatted to wrap text
(via: Format Cells Alignment tab)

for the wrap to display when the DV selection is made
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---