Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR(10) does not create new line in excel 2007
I am copying contents from multiple cells into one cell, I would like a new
line for each cell content being copied. I use the following forumula and do not see a new line being created. I found this on microsofts site; however, it does not work in Excel 2007... HELP!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR(10) does not create new line in excel 2007
Where is your formula?
Anyway try this. Copy the below formula and paste it in any the cell ="ABC"&CHAR(10)&"DEF"&CHAR(10)&"GHI"&CHAR(10)&"JKL " Then copy that cell and do right click and select paste special and select values and give ok. Now place the cursor on that cell and press F2 and give enter. Now the data will look like this ABC DEF GHI JKL -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Alan" wrote: I am copying contents from multiple cells into one cell, I would like a new line for each cell content being copied. I use the following forumula and do not see a new line being created. I found this on microsofts site; however, it does not work in Excel 2007... HELP!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR(10) does not create new line in excel 2007
Is the cell you are copy your data to formatted to "Wrap text"?
-- Rick (MVP - Excel) "Alan" wrote in message ... I am copying contents from multiple cells into one cell, I would like a new line for each cell content being copied. I use the following forumula and do not see a new line being created. I found this on microsofts site; however, it does not work in Excel 2007... HELP!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR(10) does not create new line in excel 2007
No formula is required.
Type: ABC then press (Alt+Enter), then type DEF (Alt+Enter) and so on... "Ms-Exl-Learner" wrote: Where is your formula? Anyway try this. Copy the below formula and paste it in any the cell ="ABC"&CHAR(10)&"DEF"&CHAR(10)&"GHI"&CHAR(10)&"JKL " Then copy that cell and do right click and select paste special and select values and give ok. Now place the cursor on that cell and press F2 and give enter. Now the data will look like this ABC DEF GHI JKL -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Alan" wrote: I am copying contents from multiple cells into one cell, I would like a new line for each cell content being copied. I use the following forumula and do not see a new line being created. I found this on microsofts site; however, it does not work in Excel 2007... HELP!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR(10) does not create new line in excel 2007
While the OP forgot to post it, the is using a formula to do the
concatenation (he said... "I use the following formula" in his original message), so I think he is doing something like this... =A1&CHAR(10)&B1&CHAR(10)&C1 I still believe he just needs to format the cell for "Wrap text" to solve his problem. -- Rick (MVP - Excel) "Teethless mama" wrote in message ... No formula is required. Type: ABC then press (Alt+Enter), then type DEF (Alt+Enter) and so on... "Ms-Exl-Learner" wrote: Where is your formula? Anyway try this. Copy the below formula and paste it in any the cell ="ABC"&CHAR(10)&"DEF"&CHAR(10)&"GHI"&CHAR(10)&"JKL " Then copy that cell and do right click and select paste special and select values and give ok. Now place the cursor on that cell and press F2 and give enter. Now the data will look like this ABC DEF GHI JKL -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Alan" wrote: I am copying contents from multiple cells into one cell, I would like a new line for each cell content being copied. I use the following forumula and do not see a new line being created. I found this on microsofts site; however, it does not work in Excel 2007... HELP!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format only part of a DataLabel in Excel 2007/PowerPoint 2007 char | Charts and Charting in Excel | |||
How to create a custom line and column chart in excel 2007 | Charts and Charting in Excel | |||
How do I get a line under my number that is just 1 char more? | Excel Discussion (Misc queries) | |||
Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
How do you create combination charts (line-coulmn) in excel 2007? | Charts and Charting in Excel |