L
Learner101b
I want to insert an address into a merged cell depending on a location cell.
When I use the code below, Excel does not recognize the <alt enter>. Any
ideas?
=IF(E2=1,"ABC Company<alt enter>123 Street<alt enter>Anytown, State
Zip","DEF Company<alt enter>456 Road<alt enter>Anytown, State Zip")
The <alt enter> does not work in this text box, but I think you will
understand what I want to do.
Thanks for any help.
Learner101b
When I use the code below, Excel does not recognize the <alt enter>. Any
ideas?
=IF(E2=1,"ABC Company<alt enter>123 Street<alt enter>Anytown, State
Zip","DEF Company<alt enter>456 Road<alt enter>Anytown, State Zip")
The <alt enter> does not work in this text box, but I think you will
understand what I want to do.
Thanks for any help.
Learner101b