Not sure how the replace works, if I'm trying to replace one word of a field not the whole field.
Replace "ste" with "Suite" through about 20,000 records if nothing found, do nothing
You would use the substitute function in your replace calculation. Be careful though, just replacing "ste" with "suite" would also change "steven" to "suiteven". It will take any occurence of "ste". Maybe use " ste " instead?
Retrieving data ...