combine text of multiple cells

I'm not totally sure of the question but to combine more sels into one is generally done by the function Concatenate

ex

=Concatenate(a1;" - ";b2;"and so on he goes")

was that the problem ?

Thanks very much for both reply. Your solution would be helpful for few
entries. However in my case, there are more than 30 cases. It will be time
consuming.

BTW, I notice that using the PIVOT Table wizard can do something like this
and can have some descriptive statistics. Please refer to the help of PIVOT
table in excel help.

"nijunge" wrote:

>
> I'm not totally sure of the question but to combine more sels into one
> is generally done by the function Concatenate
>
> ex
>
> =Concatenate(a1;" - ";b2;"and so on he goes")
>
> was that the problem ?
>
>
> --
> nijunge
> ------------------------------------------------------------------------
> nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404
> View this thread: http://www.excelforum.com/showthread...hreadid=398933
>
>