<div>
Use this formula:<br />
<br />
&nbsp; &nbsp;=IF(A1=&quot;&quot;,&quot;&quot;,LEFT(A1,LEN(A<wbr />1)-1))<br />
<br />
Kevin
</div>


Use this formula:

   =IF(A1="","",LEFT(A1,LEN(A1)-1))

Kevin

<div>
For data in cell A1, put the following formula in cell B1:<br />

<pre><code id="code-20-35372013-1">=LEFT(A1,LEN(A1)-1)</code></pre>
<br />
This creates a string (text) equal to the length of the leftmost text in cell A1, less one.
</div>


For data in cell A1, put the following formula in cell B1:


=LEFT(A1,LEN(A1)-1)


This creates a string (text) equal to the length of the leftmost text in cell A1, less one.

<div>
<div class="content wysiwyg-content">
I need to remove the last character of each cell in a range. &nbsp;Some cells are already empty.<br />
<br />
Assistance is greatly appreciated.
</div>
</div>


I need to remove the last character of each cell in a range.  Some cells are already empty.

Assistance is greatly appreciated.

remove last character

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