need to remove a comma from end of test in cells

J

Jerry Kinder

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
 
B

Biff

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
 
N

Niek Otten

Hi Jerry,

If it is always the last character:

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

If it could be anywhere:

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

RagDyer

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!
==============================================
 
Top