That was awesome, thanks so much for your help. One more question. I'm trying to do the same thing for fields that look like "Returned CK #"- I want them to become "Returned Check". I tried taking your code and changing the two fields like this:
Sub ReplaceText()
Dim rng, cell As Range
Dim lr As Long
lr = Cells(Rows.Count, "B").End(xlUp).Row
Application.ScreenUpdating = False
Set rng = Range("B2:B" & lr)
For Each cell In rng
If Left(cell, 7) = "Returned ck #199" Then
cell = "Returned Check"
End If
Next cell
Application.ScreenUpdating = True
End Sub

I can't it get it to make the change though. Is there anything else I need to change? The field is still in Column B.

Thanks again, you've been incredibly helpful.