Thanks. please refere to this link for the answer...
http://www.microsoft.com/office/comm...4-f97aa7ba95e4

"JE McGimpsey" wrote:

You can't do that without using an Event macro to concatenate and format
the cell.

Formulae can't change formatting, they only return values to their
calling cells.

In article ,
Sam wrote:

The prevouse post doesn't help my new problem. when i Concatenate all the
data into one cell they lose their color and boldness. i need to keep the
color and other formatting. how can i do that?