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