If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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!! |
Thread Tools | |
Display Modes | |
|
|