Soft Return

[Ali]

Can you create a formula that will create a soft return in
the content of in a cell?

 

[Alan Beban]

Huh?

Alan Beban

 

[Dan C.]

I think he may mean this.

Within a cell, when you hit enter, you jump to the next
cell. Within one cell could he drop down similar to
wrapping text. I have seen this done. But I don't know
how to do it in Excel. I have copied text from other
applications. But I am not sure how to do it directly in
Excel. Maybe?

 

[Ali]

Thanks Dan thats what I mean. You can create this
manually by select alt+enter but is there a way to do this
in a formula to automatically do it?

 

[Peo Sjoblom]

="text"&CHAR(10)&"text"

you need to turn on text wrapping under format>cells>alignment

 

[Chip Pearson]

Ali,

I'm not sure if this is what you mean, but try something like the following:

="first line" &CHAR(10)&"second line"

Ensure that you have the cell formatted for Wrap Text (Format menu, Cells,
Alignment tab).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)

 

[Ali]

Thanks guys worked nice!

-----Original Message-----
Ali,

I'm not sure if this is what you mean, but try something like the following:

="first line" &CHAR(10)&"second line"

Ensure that you have the cell formatted for Wrap Text (Format menu, Cells,
Alignment tab).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)






.

 

[Stefano Gatto]

I am not sure to understand your question, but the answer
might be:

="New"&CHAR(10)&"York"

provided the cell has the Wrap Text check box checked, in
the Alignment tab of the format cells dialog box (ctrl-1).

hope this helps.

Stefano