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)?
6 Replies
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 moduleConnect Sub Cells () Selection.MergeCells End SubI 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 & "
" & I4
