Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

excel 2007

Posted on 2011-03-17
4
Medium Priority
?
293 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

926 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