Senior Associate

Norie

Managing Director/Excel VBA Developer

Shums Faruk

Coordinator

ssblue

<div>
You could use Text to Columns from the Data Tab using the dash as a delimiter, then simply delete the unwanted columns, see the MS article and demo video<br />
<br />
<a href="https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7" rel="ugc">Split text into different columns with the Convert Text to Columns Wizard</a>
</div>


You could use Text to Columns from the Data Tab using the dash as a delimiter, then simply delete the unwanted columns, see the MS article and demo video

Split text into different columns with the Convert Text to Columns Wizard [https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7]

Training Specialist

Karen Falandays

<div>
Quick question - how would I modify &nbsp;this to pull the info between the first and second dash??<br />
<br />
0-AP-LP-6001-CB-MB &nbsp;&gt; &nbsp;result = AP<br />
0-AP-MCC-6000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt;&nbsp; result = AP<br />
0-AP-XFMR-6007 &nbsp; &nbsp; &nbsp; &nbsp; &gt;&nbsp; result = AP<br />
0-FA-5001A-B-6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt;&nbsp; result = FA
</div>


Quick question - how would I modify  this to pull the info between the first and second dash??

0-AP-LP-6001-CB-MB  >  result = AP
0-AP-MCC-6000           >  result = AP
0-AP-XFMR-6007         >  result = AP
0-FA-5001A-B-6           >  result = FA

<div>
Remove the <b>*2 </b>from the formula.<br />

<pre><code id="code-20-42752801-1">=TRIM(MID(SUBSTITUTE(A2,&quot;-&quot;,REPT(&quot; &quot;,LEN(A2))),LEN(A2),LEN(A2)))</code></pre>
</div>


Remove the *2 from the formula.


=TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2),LEN(A2)))

<div>
<div class="content wysiwyg-content">
I need to be able to pull everything between the second and third dash in a list of items.<br />
<br />
0-AP-LP-6001-CB-MB &nbsp;&gt; &nbsp;result = LP<br />
0-AP-MCC-6000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt;&nbsp; result = MCC<br />
0-AP-XFMR-6007 &nbsp; &nbsp; &nbsp; &nbsp; &gt;&nbsp; result = XFMR<br />
0-FA-5001A-B-6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt;&nbsp; result = 5001A
</div>
</div>


I need to be able to pull everything between the second and third dash in a list of items.

0-AP-LP-6001-CB-MB  >  result = LP
0-AP-MCC-6000           >  result = MCC
0-AP-XFMR-6007         >  result = XFMR
0-FA-5001A-B-6           >  result = 5001A

Excel pull data between dashes

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.