How to remove semicolons at the end of numbers but not between

[jyaoita]

Hello,

So, I'm working with numerical codes and some of them are separated by ( and some are not. When I exported the file for some reason there would be 15 semicolons attached to the codes. I would like to remove the semicolons at the end of each number but need to keep the ones in between because they separate the codes.

For example: 67890;12345;;;;;;;;;;;;;;;

and others would look like: 56789;;;;;;;;;;;;;;;

I have hundreds of these and just want to remove the 15 semicolons at the end of every number. Any help would be appreciated it. Thanks.

 

[pgc01]

Hi

If your strings are like in the examples try:

=SUBSTITUTE(TRIM(SUBSTITUTE(A1,";"," "))," ",";")

 

[FormR]

Hi, if it's always 15 then you could also try:

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