View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default need to remove a comma from end of test in cells

Hi Jerry,

If it is always the last character:

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

If it could be anywhe

=SUBSTITUTE(A1,",","")

--
Kind regards,

Niek Otten


"Jerry Kinder" wrote in message
...
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