Use this.

=IF(E2=1,"ABC Company" & CHAR(10) & "123 Street" & CHAR(10) & "Anytown,
StateZip","DEF Company" & CHAR(10) & "456 Road" & CHAR(10) & "Anytown, State
Zip")

You need to check the "wrap text" box in the cell alignment format.
--
Yanick


"Learner101b" wrote:

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 enter123 Street<alt enterAnytown, State
Zip","DEF Company<alt enter456 Road<alt enterAnytown, 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