Epic Clarity Developer

Becky Edwards

<div>
Assuming text in A! try<br />
<br />
=LEFT(LEFT(A1,FIND(&quot;[&quot;,A1,<wbr />1)),(LEN(L<wbr />EFT(A1,FIN<wbr />D(&quot;[&quot;,A1,1<wbr />)))-1))
</div>


Assuming text in A! try

=LEFT(LEFT(A1,FIND("[",A1,1)),(LEN(LEFT(A1,FIND("[",A1,1)))-1))

<div>
I used the first answer and it worked perfectly. &nbsp;Thank you everyone for your responses!
</div>


I used the first answer and it worked perfectly.  Thank you everyone for your responses!

<div>
It took three columns, but it worked perfectly. &nbsp;Thank you &nbsp;Rgonzo for help separating account number from person field.
</div>


It took three columns, but it worked perfectly.  Thank you  Rgonzo for help separating account number from person field.

<div>
My formula needs one additional column!
</div>


<div>
<div class="content wysiwyg-content">
I need to separate out the account id from the person. &nbsp;I would like to do it so that the [] are removed also. &nbsp;Can someone tell me how to do this in Excel?<br />
<br />
Example: &nbsp;PRESLEY, ELVIS [5000065005]
</div>
</div>


I need to separate out the account id from the person.  I would like to do it so that the [] are removed also.  Can someone tell me how to do this in Excel?

Example:  PRESLEY, ELVIS [5000065005]

separate parts of a field in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.