<div>
Never mind. I figured it out. &quot;-&quot; being whatever point you want to end at.<br />
<br />
=MID([Col1],1,FIND(&quot;-&quot;,[Co<wbr />l1],1)-1)
</div>


Never mind. I figured it out. "-" being whatever point you want to end at.

=MID([Col1],1,FIND("-",[Col1],1)-1)

<div>
<div class="content wysiwyg-content">
I have a field with a value at the before a &quot;-&quot; that varies in length and text after the dash. I would like to get a sub set of the portion before the dash. I've seen comments on how to extract after a certain point but not before and not if the length varies.<br />
<br />
Sample:<br />
<br />
OLB-20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; in original field <br />
<br />
OLB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;should be in calculated field<br />
<br />
OLBad-1539 &nbsp; in original field<br />
<br />
OLBad &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;should be in calculated field
</div>
</div>


I have a field with a value at the before a "-" that varies in length and text after the dash. I would like to get a sub set of the portion before the dash. I've seen comments on how to extract after a certain point but not before and not if the length varies.

Sample:

OLB-20           in original field 

OLB                should be in calculated field

OLBad-1539   in original field

OLBad            should be in calculated field

Sharepoint Calculated Field - extract piece of text from another field

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.