Column help please
 

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". this was set up
using concatenate function). However, when I pick the 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?

Ignore this post, figured it out

"galgolfer63" wrote:

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". this was set up
using concatenate function). However, when I pick the 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?