How do you remove a "," at the end of every cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example in one cell i have this
ZEZE MOTTA, WALMOR CHAGAS,
I want to remove the second "," after Walmor Chagas. But I want to keep the
first one. Any suggestions? Thanks for the help :)
 
It's always the last character?

If yes, you can use a helper column

=left(a1,len(a1)-1)
and drag down.
 
Mcobra41 said:
For example in one cell i have this
ZEZE MOTTA, WALMOR CHAGAS,
I want to remove the second "," after Walmor Chagas. But I want to keep the
first one. Any suggestions? Thanks for the help :)
Click to expand...

There's always the brute force approach:

[ ] = IF(RIGHT(A1)=",",LEFT(A1,LEN(A1)-1),A1)

or if you *know* that it ends with a comma, then don't use the IF:

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

Bill
 
=IF(RIGHT(A1,1)=",",LEFT(A1,LEN(A1)-1),A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Bill Martin -- (Remove NOSPAM from address) said:
Mcobra41 wrote:

There's always the brute force approach:

[ ] = IF(RIGHT(A1)=",",LEFT(A1,LEN(A1)-1),A1)
Click to expand...

That's not brute force, that's full error-handling (I subscribe to that
philosophy myself :-))
 
You must log in or register to reply here.

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

How to remove the cell reference in a sheet at once 3
Excel Date of first friday every month 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How can I remove the previous lock cells and keep the new ones. 2
Keep the first cell when summing a column? 1
Every cell has a page break?!?! 8
Excel Add ^ to a row of cells containing letters 3
Removal of cell objects 5

Back
Top