you could try something like

if your data is say A1 AND B1

Put in cell C1 = a1&" "&b1

or if you don't want a space

= a1&b1

regards
Pete

--
(][ This Email has been scanned by Norton AntiVirus. ][)
"xgirl" wrote in message
...
Hello, I have a list of duplicates with a comments field. I have
identified
the duplicates by sorting and then using the match function. What I need
to
do is take the comments field from each duplicate and combine them into
one.
Any suggestions?