You could do it with VBA. Not sure if/how you would do it manually.
Option Explicit
Sub sCopyText()
' need to manually select cells before running this macro
Dim cell As Range
Dim sText As String
Dim rTarget As Range
Set rTarget = Range("B5") ' change as required
rTarget = ""
sText = vbCrLf ' start with a blank row (new line)
For Each cell In Selection
' add some space, the cell value and a new line
sText = sText & " " & _
cell.Value & _
vbCrLf
Next ' cell
If Not sText = "" Then
rTarget.Value = sText
End If
End Sub
Regards, TMS
Bookmarks