If you do use the

=C2&D2
after you do it, select column E and do Edit=Copy, then immediately
Edit=Paste Special, then select Values . This will replace your formulas
with the value displayed and you can now delete the intermediate columns.

--
Regards,
Tom Ogilvy


"Ange" wrote in message
ps.com...
Thanks, Tom. That worked great! My co-worker did point out one
problem we still have. Some of our permissions have two types of
rights. For example, "(Read & Modify & Delete & Add)(Full Control)"
So what happens here is I end up with two columns for the rights. Do
you know of a way to join these? I tried "=C2&D2" in the next column
over but then I cannot get rid of these columns and just have one
column for the rights.

Thanks,
Ange