Symbol for new line in cell

[James Silverton]

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

 

[James Silverton]

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

CHAR(10)

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

 

[Sheeloo]

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]

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

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

="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:

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

 

[Sean Timmons]

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!

 

[Bob I]

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]

Sadness! Just me being Microsoft-centric...

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.