Forum Discussion
ALT+ENTER when merging cells
Hi, What is the commant when I want to merge text in multiple cells with a line brake (ALT+ENTER)?
Sorry it does not help me (or I don't get it) to merge the text in multiple cells with an ALT + Enter in between to get the text of each cell under each other.
Ron_Gastel I found the formula (wrap text = on) and the next formula
=D4 & "
" & E4 & "
" & F4 & "
" & G4 & "
" & H4 & "
" & I4
Please look the file and this Related Discussions
https://techcommunity.microsoft.com/t5/excel/concatenate-vba-solution/m-p/1665174
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Ron_Gastel As a variant, and if you have Office 2019 (PC or Mac) of you are an MS365 subscriber.
=TEXTJOIN(CHAR(10),,D4:I4)Riny_van_Eekelen Thanks. This is nice!
