Referencing text fields with in cell carriage returns

**cadmanweyland** · 04-18-2013, 08:40 PM

I am trying to link the data from one cell to another. My destination cell has the formula [=IF('Request Form'!A39="","",'Request Form'!A39)]. Which works great for values in the reference cell that do not contain carriage returns, which is possible. The problem I am running into is that if the reference cell contains a carriage return the destination cell just ignores it and crams the lines together for display purposes. Is there a way/formula I can use to force excel to display 'exactly' as entered, in cell returns and all?

Thanks in advance.

**Tony Valko** · 04-18-2013, 09:13 PM

You would have to format the cell for word wrap. A formula can only pull in a value, it can not pull in formatting.

Right click>Format Cells>Alignment tab>Wrap Text>OK

You may still have to adjust the column width/row height.

**cadmanweyland** · 04-18-2013, 09:25 PM

Ha! I didn't think this was a formatting issue, rather an issue with using the correct formula to recognize the line returns. However when I double checked that I had text wrap turned on for the destination cell, it turns out that I didn't. Turning it on caused Excel to recognize the line returns.

Thanks a bunch. I appreciate the help.

**Tony Valko** · 04-18-2013, 09:39 PM

You're welcome. Thanks for the feedback!

**cadmanweyland** · 04-18-2013, 09:41 PM

It was funny, I think you might have actually misunderstood me when I was talking about the carriage returns. But I tried it and it fixed the issue, so no worries. Anyway, again, thanks.