Entering a Return into a Formula

jbrouse

Active Member
Joined
Apr 28, 2005
Messages
329
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!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,071
Messages
5,570,023
Members
412,304
Latest member
citrus
Top