happyexchange
asked on
excel 2007
CN=Admin David Lamont,OU=IT Admin Accounts,OU=Information Technology,OU=Personnel,DC =axiseurop e,DC=local
CN=Dean Beckenham,OU=Departed Users,OU=Personnel,DC=axis europe,DC= local
CN=Maureen Henderson,OU=Managers,OU=H ousing,OU= Personnel, DC=axiseur ope,DC=loc al
CN=Bill Rands,OU=Managers,OU=Housi ng,OU=Pers onnel,DC=a xiseurope, DC=local
CN=Kelly Blake,OU=Swale Housing,OU=Administrators, OU=Housing ,OU=Person nel,DC=axi seurope,DC =local
CN=Sarah Cooper,OU=Resident Liaison Officers,OU=Housing,OU=Per sonnel,DC= axiseurope ,DC=local
CN=Kerri McNulty,OU=Resident Liaison Officers,OU=Housing,OU=Per sonnel,DC= axiseurope ,DC=local
CN=Jane Phillips,OU=Resident Liaison Officers,OU=Housing,OU=Per sonnel,DC= axiseurope ,DC=local
CN=Ken Chamberlain,OU=Managers,OU =Housing,O U=Personne l,DC=axise urope,DC=l ocal
The list above ive exported over from AD. I saved it as a csv file but all i want is the users, dont want CN or ou. Is there a excel formula to get of the cn and all the ou and dc. All i want on the spread sheet is the users names thats it.
Thank you for all your help
CN=Dean Beckenham,OU=Departed Users,OU=Personnel,DC=axis
CN=Maureen Henderson,OU=Managers,OU=H
CN=Bill Rands,OU=Managers,OU=Housi
CN=Kelly Blake,OU=Swale Housing,OU=Administrators,
CN=Sarah Cooper,OU=Resident Liaison Officers,OU=Housing,OU=Per
CN=Kerri McNulty,OU=Resident Liaison Officers,OU=Housing,OU=Per
CN=Jane Phillips,OU=Resident Liaison Officers,OU=Housing,OU=Per
CN=Ken Chamberlain,OU=Managers,OU
The list above ive exported over from AD. I saved it as a csv file but all i want is the users, dont want CN or ou. Is there a excel formula to get of the cn and all the ou and dc. All i want on the spread sheet is the users names thats it.
Thank you for all your help
ASKER
Hi i did that coomand but i got this
Dean Beckenham,Departed Users,Personnel,DC=axiseur ope,DC=loc al
Is there a way in Excel so it just shows Dean Beckenham.
Thank you
Dean Beckenham,Departed Users,Personnel,DC=axiseur
Is there a way in Excel so it just shows Dean Beckenham.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
=SUBSTITUTE(SUBSTITUTE(A1,
And copy down.