Text spacing in drop down lists

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

Guest

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
 
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.
 
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
 
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...
 
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
 
It worked perfectly!!

Thank you so much!

Debra Dalgleish said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup v. drop down box for mailing addresses 1
Formatted cell column in drop down list 1
Drop down list button hidden 4
totaling data from a drop down list 2
Splitting Text from single cell in column across multiple Columns 3
Dependent drop down dynamic range formula, off sheet. 7
Excel Drop Dowl List 0
How do I create a drop down list that fills multiple cells? 1

Back
Top