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?

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?

I think you mean you want to merge the 2 cells into 1. I forgot th
exact code, but the easy wat to do it is to use "macro - record"
merge 2 cells into 1, then stop the macro. Then view the code for th
macro, cut and paste, and viola!

xgirl Wrote:
Hello, I have a list of duplicates with a comments field. I hav
identified
the duplicates by sorting and then using the match function. What
need to
do is take the comments field from each duplicate and combine them int
one.
Any suggestions

--
thinkingfiel
-----------------------------------------------------------------------
thinkingfield's Profile: http://www.excelforum.com/member.php...fo&userid=1618
View this thread: http://www.excelforum.com/showthread.php?threadid=27678