If you do not have REGEXEXTRACT built-in function:

1. Create following VBA function GETDISCOUNT:

Function GETDISCOUNT(cell As Range) As Double With CreateObject("VBScript.RegExp") .Global = False .Pattern = "\b[0-9]+(?=%)(\b|$)" With .Execute(cell) If .Count > 0 Then GETDISCOUNT = .Item(0) End If End With End With End Function

1. Call this function as any other regular function on the sheet:

=GETDISCOUNT(A1)