| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
| Using the @ symbol in a cell | Excel Discussion (Misc queries) | |||
| Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
| A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
![James Silverton[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
