ALT+ENTER when merging cells

Copper Contributor

Hi,

What is the commant when I want to merge text in multiple cells with a line brake (ALT+ENTER)? 

6 Replies

@Ron_Gastel 

 

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.

@NikolinoDE 

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

@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_Gastel 

 

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_Eekelen Thanks. This is nice!