Forum Discussion
ALT+ENTER when merging cells
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.
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_GastelSep 16, 2020Copper Contributor
Ron_Gastel I found the formula (wrap text = on) and the next formula
=D4 & "
" & E4 & "
" & F4 & "
" & G4 & "
" & H4 & "
" & I4- NikolinoDESep 16, 2020Platinum Contributor
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)
- Riny_van_EekelenSep 16, 2020Platinum Contributor
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)- Ron_GastelSep 16, 2020Copper Contributor
Riny_van_Eekelen Thanks. This is nice!