Forum Discussion
Excel 365 Insider (2004 Click to run) CONCAT function with CHAR(10) to insert line feed not working
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)
You formula is correct, you need to wrap text
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
3 Replies
You formula is correct, you need to wrap text
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
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
- Thank you! That wasn't mentioned anywhere and I was too naive to consider it.
TheOldPuterMan
