Solved

I need to trim text from a cell.  I am not sure how to create the function in Excel

Posted on 2014-09-04
2
136 Views
Last Modified: 2014-09-04
I have this cell value of:

CN=John Doe,CN=Users,DC=mydomain,DC=int

Every cell is like this as I am getting it from Active Directory.  What I need is a function to give me just the name.  So the next cell's value is John Doe.  I think the function is trim, but not sure how to grab just the users name from this cell value.  Only thing I see common is the name starts after the "=" and there is a comma right after the name.  Your help is greatly appreciated.
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40304859
If the cell value shown is in cell A1, then this formula will extract the name only:
=MID(A1,4,FIND(",",A1)-4)

Regards,
-Glenn
0
 
LVL 4
ID: 40304916
That is Brilliant Glenn Ray.  Works great.  I am going to ask another question here shortly.  If you can figure out, I am putting Active Directory info in an access database for some other I.T. people to look at.  If all possible,  I would like to get the first and last name in two separate cells.  I will reference you and your solution in case it helps.  Thank you so much
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

735 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