A
Ali
Can you create a formula that will create a soft return in
the content of in a cell?
the content of in a cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan Beban
Huh?
Alan Beban
Alan Beban
D
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?
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?
A
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?
manually by select alt+enter but is there a way to do this
in a formula to automatically do it?
P
Peo Sjoblom
="text"&CHAR(10)&"text"
you need to turn on text wrapping under format>cells>alignment
you need to turn on text wrapping under format>cells>alignment
C
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)
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)
A
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)
.
S
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
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