In the source list, is each address all in one cell, or is it in several
columns?

If it's in columns, that you've concatenated for the dropdown, e.g.:

=A2&", " & B2

you could use the CHAR(10) function instead of commas, e.g.

=A2&CHAR(10)&B2

Cathy Landry wrote:
If I have 1000 lines I will need to do that for each one?

"Debra Dalgleish" wrote:


In your source list, press Alt + Enter where you want the lines to break
Then, in the cell that contains the dropdown list, choose FormatCells
On the Alignment tab, add a check mark to Wrap Text, and click OK

In the dropdown list, you'll see a box character where the line breaks
are, but they won't appear in the cell.

Cathy Landry wrote:

Hello,

I have a drop down list that contains clinic name/address/city/st/zip/phone#
in a merged cell. Is there anyway to format the spacing so that it will look
like a proper ship-to address?

Thank you
Cathy


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html