<div>
Can you clarify which part of the string you need to keep?<br><br>RIGHT function returns the number of characters from the right hand end, your question then says you need to remove everything at the end.
</div>


Prof Serv

Candace Hagood

<div>
Hi,<br>You can use instr function to get position of specific character<br><br><pre><code class="code-1 nolinks" id="code-20-43289780-1"><span>DIM S0 as String, DimStr as String</span>
<span>DimStr="YourBString"</span>
<span>DIM P0 as Integer</span>
<span>P0=instr(DimStr,"B")</span>
</code></pre><br>Then get substring till that specific character like<pre><code class="code-1 nolinks" id="code-20-43289780-2"><span>S0=Mid(DimStr,1,P0)</span>
<span></span>
</code></pre><br><br>
</div>


<div>
Assuming your string is in cell A2, then you may try this...<br><br><pre><code class="code-1 nolinks" id="code-20-43289804-1"><span>=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2)))</span>
</code></pre>
</div>


<div>
@Neeraj - I knew there was a simpler way with substitute; that works when you want to keep the text after the last "delimiter" character but need confirmation from Author as to which part they require to remain.<br><br>I had originally formulated mine using the TRIM and REPT functions but just looked way too complicated.
</div>


<div>
I believe it is an easy thing to do in Power Query. Do you have some examples? &nbsp;Below is an example of Excel's Power Query.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561334/EE.xlsx" rel="ugc">EE.xlsx</a>
</div>


EE.xlsx

<div>
<div class="content wysiwyg-content fr-view">
Hello,<br>I have an excel sheet with many rows of serial numbers. &nbsp;I need to perform a =RIGHT on the cells in one of the columns. The problem is the values vary in length. The one issue of consistency is that I need to remove everything at the end until the LAST dash. &nbsp; Any ideas appreciated. <br><br>Thank you!
</div>
</div>



Hello,
I have an excel sheet with many rows of serial numbers.  I need to perform a =RIGHT on the cells in one of the columns. The problem is the values vary in length. The one issue of consistency is that I need to remove everything at the end until the LAST dash.   Any ideas appreciated.
Thank you!

EXCEL remove characters in string from Right until a certain character

Excel Table

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.