Entering a Return into a Formula

[jbrouse]

Greetings,

I have a formula in cell D4 of one worksheet that pulls in the value of 2 other cells from a different worksheet. Currently, I can bring them in using the following formula

=IF(ISBLANK('Sheet1'!E3),"",'Sheet1'!F4&" "&" - "&'Sheet1'!E3)

which will bring it in in the following format

"Text1 - Text2"

I would like to have it come in as

"Text1
Text2"

How can I input a hard return into the formula so that it will place the two texts into separate rows within the cell?

Thanks in advance for any assistance!

 

[Richard Schollar]

=IF(ISBLANK('Sheet1'!E3),"",'Sheet1'!F4 & CHAR(10) & 'Sheet1'!E3)

Regards

Richard

 

[Richard Schollar]

and format the cells to "Wrap Text"