Endswith Calculation

[ashleyinman]

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 solution]

Just set the formula to

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

[CharlieS · Accepted solution]

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