Text spacing in drop down lists

C

Cathy Landry

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
 
D

Debra Dalgleish

In your source list, press Alt + Enter where you want the lines to break
Then, in the cell that contains the dropdown list, choose Format>Cells
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.
 
D

Debra Dalgleish

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
 
C

Cathy Landry

Yes, they are all in one cell.

Thank you!

Debra Dalgleish said:
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
Click to expand...
 
D

Debra Dalgleish

You could try the following in a copy of your data:

Select the column of names/addresses
Choose Edit>Replace
In the Find What box, type a comma
In the Replace With box, hold the Alt key, and on the number keypad
type: 0010
(you won't see anything in the Replace With box)
Click the Replace All button
Click OK to confirm the replacement
Click Close
 
Top