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,
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks