CHAR(10) does not create new line in excel 2007

[Alan]

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

 

[Ms-Exl-Learner]

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

 

[Rick Rothstein]

Is the cell you are copy your data to formatted to "Wrap text"?

 

[Teethless mama]

No formula is required.

Type: ABC then press (Alt+Enter), then type DEF (Alt+Enter) and so on...

 

[Rick Rothstein]

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.