View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VCKW VCKW is offline
external usenet poster
 
Posts: 8
Default 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.