consider your text lies in cell A1, then use the following formula:

=RIGHT(A1,LEN(A1)-FIND("=",A1))


- Mangesh



"TheLazer" wrote in message
...
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?