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


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

<div>
<div class="content wysiwyg-content">
I have this cell value of:<br />
<br />
CN=John Doe,CN=Users,DC=mydomain,D<wbr />C=int<br />
<br />
Every cell is like this as I am getting it from Active Directory. &nbsp;What I need is a function to give me just the name. &nbsp;So the next cell's value is John Doe. &nbsp;I think the function is trim, but not sure how to grab just the users name from this cell value. &nbsp;Only thing I see common is the name starts after the &quot;=&quot; and there is a comma right after the name. &nbsp;Your help is greatly appreciated.
</div>
</div>


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.

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

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.