will the second one always be butt up against the first so there is no space

do Edit=Replace
what: " ("
Replace With: "|("

so you don't get ")|(" and a split on the second one.

If there is a single space then before you do it do

do Edit=Replace
what: ") ("
Replace With: (<==leave blank)

then

do Edit=Replace
what: " ("
Replace With: "|("


of course you can record a macro to do this same operation by turning on the
macro recorder while you do it manually

in all cases, the "" are for clarity and would not be included.

--
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