Endswith Calculation

Question

I'm looking to replace GM400168(75) to only show GM400168

I've tried using the formula below.

IF ENDSWith([Name], '(75)')
THEN "" ELSE [Name] ENDIF

But the calculation is not working. Any ideas how to adjust this?

BrandonB · Accepted Answer

Just set the formula to

Replace([Name],"(75)","")

CharlieS · Accepted Answer

I recommend the following if statement so only '(75)' strings that occur at the end of the string are replaced (and not '(75)' that occurs anywhere else).

IF Right([Name],4)=='(75)' THEN Left([Name],Length([Name])-4)
ELSE [Name] ENDIF