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
132 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: 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…
Viewers will learn how to find and create templates in Excel 2013.
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …

831 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