Sep 16 2020 12:20 AM
Hi,
What is the commant when I want to merge text in multiple cells with a line brake (ALT+ENTER)?
Sep 16 2020 12:25 AM
To merge Excel cells, select them, then press Alt + R + M + V in sequence.
Note: Unlike most key combinations, the key here is to press the keys one after the other and not at the same time.
or with VBA
Into the workbook module (Open)
Application OnKey "{F10}", "Connect cells"
-In this case, clicking on key F10 triggers a macro to connect cells
In normal module
Connect Sub Cells ()
Selection.MergeCells
End Sub
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Sep 16 2020 01:30 AM
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.
Sep 16 2020 02:01 AM
@Ron_Gastel I found the formula (wrap text = on) and the next formula
=D4 & "
" & E4 & "
" & F4 & "
" & G4 & "
" & H4 & "
" & I4
Sep 16 2020 02:14 AM
@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)
Sep 16 2020 02:16 AM
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)