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
|