excel 2007

CN=Admin David Lamont,OU=IT Admin Accounts,OU=Information Technology,OU=Personnel,DC=axiseurope,DC=local
CN=Dean Beckenham,OU=Departed Users,OU=Personnel,DC=axiseurope,DC=local
CN=Maureen Henderson,OU=Managers,OU=Housing,OU=Personnel,DC=axiseurope,DC=local
CN=Bill Rands,OU=Managers,OU=Housing,OU=Personnel,DC=axiseurope,DC=local
CN=Kelly Blake,OU=Swale Housing,OU=Administrators,OU=Housing,OU=Personnel,DC=axiseurope,DC=local
CN=Sarah Cooper,OU=Resident Liaison Officers,OU=Housing,OU=Personnel,DC=axiseurope,DC=local
CN=Kerri McNulty,OU=Resident Liaison Officers,OU=Housing,OU=Personnel,DC=axiseurope,DC=local
CN=Jane Phillips,OU=Resident Liaison Officers,OU=Housing,OU=Personnel,DC=axiseurope,DC=local
CN=Ken Chamberlain,OU=Managers,OU=Housing,OU=Personnel,DC=axiseurope,DC=local


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
happyexchangeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jimyXConnect With a Mentor Commented:
Sorry I misread your data. Please try this one:
=MID(A1,4,FIND(",",A1)-4)
0
 
jimyXCommented:
You can use this formula for A1:
=SUBSTITUTE(SUBSTITUTE(A1,"CN=",""),"OU=","")

And copy down.
0
 
happyexchangeAuthor Commented:
Hi i did that coomand but i got this

Dean Beckenham,Departed Users,Personnel,DC=axiseurope,DC=local
Is there a way in Excel so it just shows Dean Beckenham.

Thank you
0
 
happyexchangeAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.