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

M

Mcobra41

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

Dave Peterson

It's always the last character?

If yes, you can use a helper column

=left(a1,len(a1)-1)
and drag down.
 
G

Guest

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
 
B

Bob Phillips

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

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