<div>
I would try this:<br />
<br />
=IF(LEFT(A1,2)=&quot;,&quot;,SUBSTIT<wbr />UTE(A1,&quot;,&quot;<wbr />,&quot;&quot;),IF(RI<wbr />GHT(A1,2)=<wbr />&quot;--&quot;,SUBST<wbr />ITUTE(A1,&quot;<wbr />,&quot;,&quot;&quot;), A1)) <br />
<br />
I got the idea from one of the answers <a href="http://stackoverflow.com/questions/28091210/find-a-pattern-in-string-and-remove-that-pattern-of-the-string-from-excel-cells" rel="ugc">here</a>. &nbsp;If a comma is the right most character and left most character, one comma will be replaced with nothing.
</div>


I would try this:

=IF(LEFT(A1,2)=",",SUBSTITUTE(A1,",",""),IF(RIGHT(A1,2)="--",SUBSTITUTE(A1,",",""), A1))

I got the idea from one of the answers here [http://stackoverflow.com/questions/28091210/find-a-pattern-in-string-and-remove-that-pattern-of-the-string-from-excel-cells].  If a comma is the right most character and left most character, one comma will be replaced with nothing.

<div>
thanks for the great suggestion.
</div>


<div>
<div class="content wysiwyg-content">
How do I modify the following to handle if the results only return a comma, to remove the comma.<br />
<br />
=VLOOKUP(MainFormTbl[Compa<wbr />ny Name],BillingInfo[#All],5,<wbr />FALSE) &amp;&nbsp;&quot;, &quot;&nbsp;&amp;VLOOKUP(MainFormTbl[Compa<wbr />ny Name],BillingInfo[#All],6,<wbr />FALSE) &amp;&nbsp;&quot; &nbsp;&quot; &amp;VLOOKUP(MainFormTbl[Compa<wbr />ny Name],BillingInfo[#All],7,<wbr />FALSE)<br />
<br />
results = City, ST &nbsp;ZipCode
</div>
</div>


How do I modify the following to handle if the results only return a comma, to remove the comma.

=VLOOKUP(MainFormTbl[Company Name],BillingInfo[#All],5,FALSE) & ", " &VLOOKUP(MainFormTbl[Company Name],BillingInfo[#All],6,FALSE) & "  " &VLOOKUP(MainFormTbl[Company Name],BillingInfo[#All],7,FALSE)

results = City, ST  ZipCode

Remove comma if no data found

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