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

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 wrote:

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 :)

--

Dave Peterson

Mcobra41 wrote:
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 :)

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)


"Mcobra41" wrote in message
...
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 :)

"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
Mcobra41 wrote:

There's always the brute force approach:

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

That's not brute force, that's full error-handling (I subscribe to that
philosophy myself :-))