Merge Cells in a Row to one Cell and text is NOT in a line
I would like to merge a few cells for a row
Michael 23, Jalan 222 Kuala Lumpur Malaysia
and make it within ONE CELL in this format (like using Alt+Enter within a
CELL)
Michael
23, Jalan 222
Kuala Lumpur
Malaysia
but NOT in one line format (like using CONCATENATE or & ),
Michael 23, Jalan 222 Kuala Lumpur Malaysia.
This is possible in MS. Word, but I have a long list, I do not want to do it
manually merge it one by one using MS. Word.
Thank you.
|