Replace last character (right-most) in a cell

[EconSean]

Greetings everyone,

I am trying to replace the last character (furthest to the right) in a cell, in most cases.

Specifically, I have thousands of rows, and in the vast majority of cases (but not all) the cell ends with a semicolon. I would like to get rid of that.

Seems easy enough, but I cannot come up with anything. There are other semicolons throughout my data, and I need them to remain. It is only in those instances that the semicolon is the last character in the cell do I want to replace them.

Any help will be greatly appreciated.

Regards,

Sean

 

[ExcelChampion]

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

 

[EconSean]

Wow, thanks so much Todd.

 

[ExcelChampion]

You are very welcome!

 

[jindon]

Hi
try

=If(Right(A1)=";",Substitute(A1,";","",Len(A1)-Len(Substitute(A1,";",""))),A1)

 

[ExcelChampion]

ah, Jindon helped me notice that you mention that not all have the semi colon...so:

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

 

[EconSean]

Jindon and Todd, thank you both for your prompt replies and valuable insight.

Take care,

Sean

 

[Peter_SSs]

Here's another possibility:
=LEFT(A1,LEN(A1)-(RIGHT(A1)=";"))