Excel - Remove character from end of string
<p>I have some data in excel, from which I want to remove underscore (_) from end of the string. Is it possible to do it? If so, please help.
For example:</p>

<pre><code>AA_BB_CC_
AA_BB_CC_DD
AA_BB_
</code></pre>

<p>From the first and third line, I want to remove the '_' from end of the string only. But no changes to be made to second line.</p>

<p>Thanks,</p>