Inserting a newline in an Excel cell (without using VBA)

[roraima07]

I have two name ranges defined: StreetAddress (value = "24 Santa Monica Blvd.") and CityStateZip (value = "Los Angeles, CA 90510").

How can I get Excel to produce the result below in a single cell without using VBA:

Joe lives at:
24 Santa Monica Blvd.
Los Angeles, CA 90510

I think I can use:

="Joe lives at:"&StreetAddress&CityStateZip"

but am unable to insert the required Ctrl-J or Alt+0010 characters to force a newline.

Any ideas, anyone?

Thanks in advance.

 

[Smallman]

hi roraima07

The following should go OK. Just ensure you have the cell formatted set to Wrap Text.

="Jack lives at:"&CHAR(10)&StreetAddress&CHAR(10)&CityStateZip

Eg file attached.

Take care

Smallman

 

[roraima07]

Many thanks, Smallman. It worked perfectly!

Much appreciated .

roraima07

 

[Smallman]

Glad it helped.

Take it easy

Smallman