Select the permissions column

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

now do the text to columns and type in the vertical line as the delimiter.

--
Regards,
Tom Ogilvy


"Ange" wrote in message
ps.com...
Okay, I spoke too soon. This worked on the items that did not have any
additional spaces in them such as (Read), but what do I do about the
ones that additional spaces like (Full Control) or (Read & Modify &
Delete & Add)?

Thanks,
Ange

Tom Ogilvy wrote:
select the permissions column and do Data=Text to Columns, Select
delimited in the first tab, then select space as the delimiter.

--
Regards,
Tom Ogilvy