Nope.

Formulas don't support this kind of formatting.

You could convert it to a value and do what you want, though.

VCKW wrote:

Thans...

Is there anyway to maintain the FONT SIZE and TYPE (Bold, Arial) too in the
formula after merging? Since I need the name to be BOLD and 12 points in size
while the rest are normal and 8 points in size.

Thank you!

regards
VC

"David Biddulph" wrote:

=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1
and Format Cells/ Alignment/ Wrap text
--
David Biddulph

"VCKW" wrote in message
...
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.






--

Dave Peterson