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

Hi!

If the only commas in the cells are the ones at the end of the string, use
EditReplace.

OR this formula:

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

Biff

"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

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

=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

If there's only a comma at the end, TTC will eliminate it, and leave the
original text, not formulas.

Select the column, then:
<Data <Text To Columns
Click "Delimited", then <Next,
Click "Comma", then <Finish.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"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