need to remove a comma from end of test in cells

  • Thread starter Thread starter Jerry Kinder
  • Start date Start date
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
 
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
 
Hi Jerry,

If it is always the last character:

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

If it could be anywhere:

=SUBSTITUTE(A1,",","")
 
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!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count no. of commas (,) in a string in a cell 3
Formula Help 0
Help with blank cells when concatenating 11
Replace Comma with Dash 3
How to count commas in a cell? 5
cell to have comma-delimited values based on text 8
Count the number of Commas found in cell A2 3
count no. of times a character occurs in a cell 2

Back
Top