Excel 365 Insider (2004 Click to run) CONCAT function with CHAR(10) to insert line feed not working

[TheOldPuterMan]

I'm attempting to insert line feeds into text using a function. From everything I can find the CHAR(10) used within CONCAT, TEXTJOIN or plain old "&" should give me the results I'm looking for but... NOT.

My test code is =CONCAT("A",CHAR(10),"B",CHAR(10),"C")

The expected result is:

A

B

C

The actual result is ABC

TEXTJOIN and "&" gives me the same result

I've copied and pasted sample formulas but my results are totally different from the examples.

PC, Windows 10 Pro Excel 365 Insider (Not online) All update applied

Help anyone, please

Thanks, TheOldPuterMan (AKA John)

[#2 · Accepted solution]

hi @TheOldPuterMan 

You formula is correct, you need to wrap text 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

 

[#3 · Accepted solution]

If you find the above solution resolved your query don't forget mark as Official Answer.

[#4]

Thank you! That wasn't mentioned anywhere and I was too naive to consider it.
TheOldPuterMan

[#5]

@Faraz Shaikh 

Uhhhh Doh! in the vernacular of Homer Simpson

My Bad on that, I presumed that the line feed would be automatic. Kinda shows my age huh. Used to work on the old Dot Matrix keyboards I used long ago and on ASCII based terminals. I've been around a long time and every now and again it shows.

The OldPuterMan     AKA John