Column help please

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

Guest

I have addresses in one column in an excel worksheet. When I highlite the
address, it shows up correctly in the fx box (showing name on one line,
address on the next, city, state and zip on last “line). However, when I pick
the any address in the drop down box I made, the address shows up as one long
line, not as the multiple lines I need.
How can I have this show up as I need?
 
Started answer, before realizing you'd found your solution.
But even if you find the solution, it may help others if you post
the answer. So ...

If it is for one cell and you see square printer's bullets between the
what are to be lines within the cell you need to turn on cell wrap.

Turn on cell wrap for the entire column
select the column, Format, Cells, alignment, [x] cell wrap

That will wrap cells at a char(10) which is a line feed (LF) character.
 
Back
Top