View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ange[_4_] Ange[_4_] is offline
external usenet poster
 
Posts: 5
Default Find Code Needs Help

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