need to remove a comma from end of test in cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry Kinder - 13 Dec 2005 19:25 GMT

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 to this Message

Biff - 13 Dec 2005 19:33 GMT

Hi!

If the only commas in the cells are the ones at the end of the string, use
Edit>Replace.

OR this formula:

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

Biff

>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.
[quoted text clipped - 3 lines]
> Thank you,
> Jerry Kinder

Reply to this Message

Niek Otten - 13 Dec 2005 19:36 GMT

Hi Jerry,

If it is always the last character:

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

If it could be anywhere:

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

Signature

Kind regards,

Niek Otten

>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.
[quoted text clipped - 3 lines]
> Thank you,
> Jerry Kinder

Reply to this Message

David Billigmeier - 13 Dec 2005 19:40 GMT

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

Signature

Regards,
Dave

> 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.
[quoted text clipped - 3 lines]
> Thank you,
> Jerry Kinder

Reply to this Message

RagDyer - 14 Dec 2005 01:25 GMT

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>.

Signature

HTH,

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

> 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.
[quoted text clipped - 3 lines]
> Thank you,
> Jerry Kinder

Reply to this Message