Excel subroutine to merge the cells AND contents of the select range.

excelMergeContents.vba

' This excel subroutine that will merge the contents of a selected range,
' concantenate and move all the contents into into the top cell.
'
' keywords: merge, cell, concatenate, join, range, selection
'
' The MIT License (MIT)
' Copyright (c) 2016 Lloyd Leung
'
' Permission is hereby granted, free of charge, to any person obtaining a 
' copy of this software and associated documentation files (the "Software"),
' to deal in the Software without restriction, including without limitation
' the rights to use, copy, modify, merge, publish, distribute, sublicense,
' and/or sell copies of the Software, and to permit persons to whom the
' Software is furnished to do so, subject to the following conditions:
'
' The above copyright notice and this permission notice shall be included
' in all copies or substantial portions of the Software.
'
' THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS
' OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
' FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
' THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR
' OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
' ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
' OTHER DEALINGS IN THE SOFTWARE.
'
'

Sub MergeContents()
    Dim ContactString
    Set TxtRng = Range(Selection.Cells(1).Address(0, 0))

    For Each cell In Selection
        ConCatString = ConCatString & vbCrLf & cell.Value
        cell.Value = ""
    Next cell

    TxtRng.Value = ConCatString
End Sub