Use Find and Replace
Find "CN=" (no quotes)
Replace with "" (no quotes) -(absolutely nothing - dont even touch the
field)
This will leave you with just the name whatever it is.
Try the first couple to ensure proper result then "all"
--
Don C


"TheLazer" wrote:

I have a long list of cells that all contain the text 'CN=User Name'. I
would like to remove all the text to the left of User Name leaving me with
just that. Is there a function that can do this for me and if not could I
and how would I go about doing it in VBA?