Does anyone know how to remove a semicolon from a cell?

[Jumper23]

In a cell is different names separated by a space and semicolon, at the last name in the cell there is a semicolon. I am trying to find some way to remove the semicolon that comes after the very last name in the cell. I want to keep the other semicolons that are in the cell and only want to remove the semicolon that comes after the last name.

Example of list of names- Adam; Apple; Bob; Brad; John; Kendra Sam; Tad; Tom;

I want to find a way to remove the semicolon that is at the end of the last name which is Tom.

I have attached an example of the excel sheet.

Thanks in advance.

Jumper23

[ChemistB]

In B1
=LEFT(A1, LEN(A1)-1)
Then you can copy and paste special > Values back over column A
Is that what you need?

[Jumper23]

Hello ChemistB,

I don't think my last message got posted.

I have run into a problem, I only want to remove the last semicolon after the last name. This function here is removing the last text but I only what to remove the last semicolon. I have some cells that do not have a semicolon at the end and this function removes the last text which is the last letter of the name. Is there some way to correct this?
I have attached an excel sheet as an example.
Thank you for the fast reply.

Jumper23

[Vraag en antwoord]

=left(a1, len(a1)-(right(a1,1)=";"))  

[Jumper23]

Hello Vraag en antwoord,

Thank you for this it really did work.

Jumper23

[Jumper23]

deleted no need

[AliGW]

You've started a new thread for this and I have already explained it. Don't duplicate queries, please.

RIGHT(A5,1)=";"

evaluates to TRUE if there is a semi-colon at the end of A5 and FALSE if not. Excel sees TRUE as 1 and FALSE as 0.

LEN(A5) returns the number of characters in A5. The result of the RIGHT statement is then deducted from this.

=LEFT(A5,...)

This returns the number of characters at the left of A5 determined by the calculation explained above, so one fewer than LEN(A5) if there is a semi-colon at the end, and the same as LEN(A5) if not.

Evaluate Formula on the Formulas ribbon with help you with this sort of formula analysis.

[AliGW]

So, did this help at all??? Some feedback would have been nice ...

[Jumper23]

Hello AliGW,

This has been helpful thank you very much for you time and skills with this issue.

Jumper23