Another way..........if your list is in column A, put this in B1 and copy
down.........

=MID(A1,FIND("=",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3



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