Solved

excel 2007

Posted on 2011-03-17
4
278 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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 …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

707 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

20 Experts available now in Live!

Get 1:1 Help Now