Thread: need to remove a comma from end of test in cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default need to remove a comma from end of test in cells
=SUBSTITUTE(A1,",","")


--
Regards,
Dave


"Jerry Kinder" wrote:

I have a column of text that has a comma at the end of of the text in each
cell. How can I remove the comma from each cell.

Is there a formula to do this??

Thank you,
Jerry Kinder



Reply With QuoteReply With Quote