align 3 concatenated strings for column appearnace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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

---
 
Back
Top