<div>
You can use the Replace command. Select the cells to edit, press CTRL+H, enter &quot;&nbsp;USD&quot; in the Find field and leave the replace field empty. Replace all.<br />
<br />
Kevin
</div>


You can use the Replace command. Select the cells to edit, press CTRL+H, enter " USD" in the Find field and leave the replace field empty. Replace all.

Kevin

<div>
You can also use this formula to add the values WITHOUT first removing the USD and $:<br />
<br />
&nbsp; &nbsp;=SUM(VALUE(SUBSTITUTE(SUBS<wbr />TITUTE(A1:<wbr />A2,&quot; USD&quot;,&quot;&quot;),&quot;$&quot;,&quot;&quot;)))<br />
<br />
Enter the formula by pressing CTRL+SHIFT+ENTER.<br />
<br />
Kevin
</div>


You can also use this formula to add the values WITHOUT first removing the USD and $:

   =SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A1:A2," USD",""),"$","")))

Enter the formula by pressing CTRL+SHIFT+ENTER.

Kevin

<div>
<div class="content wysiwyg-content">
I have a column of numbers formatted like this $-175.15 USD. How to total the column and remove the USD ?<br />
<br />

</div>
</div>


I have a column of numbers formatted like this $-175.15 USD. How to total the column and remove the USD ?



Remove Text from a number

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