Solved

excel 2007

Posted on 2011-03-17
4
279 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:happyexchange
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:jimyX
ID: 35157645
You can use this formula for A1:
=SUBSTITUTE(SUBSTITUTE(A1,"CN=",""),"OU=","")

And copy down.
0
 

Author Comment

by:happyexchange
ID: 35158047
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
 
LVL 24

Accepted Solution

by:
jimyX earned 500 total points
ID: 35158095
Sorry I misread your data. Please try this one:
=MID(A1,4,FIND(",",A1)-4)
0
 

Author Closing Comment

by:happyexchange
ID: 35158421
Thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Outlook Free & Paid Tools
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now