Combining Cells

[Guest]

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?

 

[OZDOC1050]

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

 

[thinkingfield]

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!