Formula to remove part of text from cell

Hi,

The cell content is CPPK-$1*25

We want to be able to change it to: CPPK-$1

So remove *25 from any cells that have it on a column.

Looking for function or formula for that.

Thanks,

David

Hi & welcome to the board.
How about
=REPLACE(I2,FIND("*",I2&"*"),LEN(I2),"")

If that string is in A1, you could use this:

=SUBSTITUTE(A1,"*25","")

or another way:

=IF(ISNUMBER(FIND("*25",A1)),LEFT(A1,LEN(A1)-3),A1)

Hope this helps.

Pete