VBA - Change formula to value if a certain Condition is met

This is not especially hard but I am not clear on what you mean by "formula path". What exactly does the formula look like?

Here is the idea but unable to perform a reliable test without your file. Also, to confirm, you want to check cells in all 26 columns?

EDIT: The parameters were reversed in my InStr call. See red for correction

Public Sub Convert()

   Dim Cell As Range
   
   Application.ScreenUpdating = False
   Application.Calculation = xlCalculationManual
   
   For Each Cell In Range("A1:Z1000")
   
      If InStr(Cell.Formula2, "SM Input") = 0 Then
         Cell.Value = Cell.Value
      End If
   
   Next Cell
   
   Application.Calculation = xlCalculationAutomatic
   Application.ScreenUpdating = True

End Sub

Try this:

PHP Code: 

Sub test()
Dim ce As Range
For Each ce In ActiveSheet.UsedRange
    If InStr(1, ce.Formula, "SM Input") = 0 Then
        ce.Value = ce.Value
    End If
Next
End Sub