Symbol for new line in cell
 

Hello All!

This may be a dumb question but I've no idea how to do it. I need to
enter the new line character in a concatenation to get text on two lines
in a single cell. I know that if I were entering the data from scratch I
would use ALT+ENTER. Is there a symbol for this in Excel?

TIA
--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

CHAR(10)
--
David Biddulph

"James Silverton" wrote in message
...
Hello All!

This may be a dumb question but I've no idea how to do it. I need to enter
the new line character in a concatenation to get text on two lines in a
single cell. I know that if I were entering the data from scratch I would
use ALT+ENTER. Is there a symbol for this in Excel?

TIA
--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

David wrote on Wed, 8 Oct 2008 22:08:13 +0100:

CHAR(10)
--
David Biddulph

"James Silverton" wrote in
message ...
Hello All!

This may be a dumb question but I've no idea how to do it. I need to
enter the new line character in a concatenation to
get text on two lines in a single cell. I know that if I were
entering the data from scratch I would use ALT+ENTER. Is
there a symbol for this in Excel?

Thanks for the quick reply! So I should have been looking in a list of
ASCII characters rather than "insert symbol". Kicks self!

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

Its ASCII code is 10

You can try
=Concatenate("First Line",Char(10),"Second Line")

or

="First Line" & Char(10) & "Second Line")

You will have to format the cells as WRAP TEXT to see the effect otherwise
you will see a square...

"James Silverton" wrote:

Hello All!

This may be a dumb question but I've no idea how to do it. I need to
enter the new line character in a concatenation to get text on two lines
in a single cell. I know that if I were entering the data from scratch I
would use ALT+ENTER. Is there a symbol for this in Excel?

TIA
--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

Sheeloo wrote on Wed, 8 Oct 2008 14:19:01 -0700:

You can try
=Concatenate("First Line",Char(10),"Second Line")

or

="First Line" & Char(10) & "Second Line")

You will have to format the cells as WRAP TEXT to see the
effect otherwise you will see a square...

"James Silverton" wrote:

Hello All!

This may be a dumb question but I've no idea how to do it. I
need to enter the new line character in a concatenation to
get text on two lines in a single cell. I know that if I were
entering the data from scratch I would use ALT+ENTER. Is
there a symbol for this in Excel?


Thanks very much also, especially for the tip about Wrap Text!

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

James, just an FYI, if your question is answered go ahead and click Yes at
the bottom of the post or posts that have helped you.

This way you give credit to the helper and also let others know you no
longer need assistance.

The more people we help, the nicer our little icon looks! :-)

"James Silverton" wrote:

Sheeloo wrote on Wed, 8 Oct 2008 14:19:01 -0700:

You can try
=Concatenate("First Line",Char(10),"Second Line")

or

="First Line" & Char(10) & "Second Line")

You will have to format the cells as WRAP TEXT to see the
effect otherwise you will see a square...

"James Silverton" wrote:

Hello All!

This may be a dumb question but I've no idea how to do it. I
need to enter the new line character in a concatenation to
get text on two lines in a single cell. I know that if I were
entering the data from scratch I would use ALT+ENTER. Is
there a symbol for this in Excel?


Thanks very much also, especially for the tip about Wrap Text!

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

Sorry Sean but that little item isn't a feature of newsgroups nor is it
available in news readers. It is only available if you access this
newsgroup using your browser, through the web interface that microsoft
provides.

Sean Timmons wrote:

James, just an FYI, if your question is answered go ahead and click Yes at
the bottom of the post or posts that have helped you.

This way you give credit to the helper and also let others know you no
longer need assistance.

The more people we help, the nicer our little icon looks! :-)

"James Silverton" wrote:


Sheeloo wrote on Wed, 8 Oct 2008 14:19:01 -0700:


You can try
=Concatenate("First Line",Char(10),"Second Line")

or

="First Line" & Char(10) & "Second Line")

You will have to format the cells as WRAP TEXT to see the
effect otherwise you will see a square...

"James Silverton" wrote:

Hello All!

This may be a dumb question but I've no idea how to do it. I
need to enter the new line character in a concatenation to
get text on two lines in a single cell. I know that if I were
entering the data from scratch I would use ALT+ENTER. Is
there a symbol for this in Excel?


Thanks very much also, especially for the tip about Wrap Text!

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

Symbol for new line in cell
 

Sadness! Just me being Microsoft-centric...

"Bob I" wrote:

Sorry Sean but that little item isn't a feature of newsgroups nor is it
available in news readers. It is only available if you access this
newsgroup using your browser, through the web interface that microsoft
provides.

Sean Timmons wrote:

James, just an FYI, if your question is answered go ahead and click Yes at
the bottom of the post or posts that have helped you.

This way you give credit to the helper and also let others know you no
longer need assistance.

The more people we help, the nicer our little icon looks! :-)

"James Silverton" wrote:


Sheeloo wrote on Wed, 8 Oct 2008 14:19:01 -0700:


You can try
=Concatenate("First Line",Char(10),"Second Line")

or

="First Line" & Char(10) & "Second Line")

You will have to format the cells as WRAP TEXT to see the
effect otherwise you will see a square...

"James Silverton" wrote:

Hello All!

This may be a dumb question but I've no idea how to do it. I
need to enter the new line character in a concatenation to
get text on two lines in a single cell. I know that if I were
entering the data from scratch I would use ALT+ENTER. Is
there a symbol for this in Excel?


Thanks very much also, especially for the tip about Wrap Text!

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not