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!!

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!!

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!!

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!!

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!!