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)?
Ron_Gastel I found the formula (wrap text = on) and the next formula
=D4 & "
" & E4 & "
" & F4 & "
" & G4 & "
" & H4 & "
" & I4
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!