Column help please

G

galgolfer63

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?
 
Top