It sounds like the simplest edit in a spreadsheet. Take one word out of a column and leave everything else alone.
Real columns make it harder. The word shows up capitalized in some rows and lowercase in others. Sometimes it has a period, sometimes not. And whatever you delete leaves a gap behind.
The Old Way (SUBSTITUTE)
SUBSTITUTE swaps one string for another. Replace the word with an empty string and it disappears.
=SUBSTITUTE(A2, "Inc.", "")SUBSTITUTE is case sensitive, so "inc." and "INC." survive. You add a nest for each variant, then wrap the whole thing in TRIM because deleting a middle word leaves two spaces where there was one.
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, "Inc.", ""), "INC.", ""), "inc", ""))There is a worse failure hiding in that formula. Removing the bare string "inc" also eats the letters inside "Cincinnati" and "Incorporated". SUBSTITUTE matches characters, not words, and it has no idea where a word starts or stops.
The FITS Way (Just Ask)
With FITS, you say which word to drop and the AI treats it as a word.
=FITS("Remove the word Inc from this company name and fix the spacing: " & A2)Case variants and the trailing period are handled without extra nesting. "Cincinnati Media" comes back untouched, because the instruction is about a word rather than a run of characters. The spacing is cleaned up in the same pass.
When to Use Each
If the word appears in exactly one casing and never inside another word, SUBSTITUTE is free and instant. Reach for =FITS() when casing varies, when the word is a substring of other words, or when the deletion leaves spacing to repair. Nearby jobs work the same way: replacing text without nesting SUBSTITUTE, trimming the extra spaces left behind, and removing everything after a character. The full tour is in automating Google Sheets tasks you used to need regex for.
Stop Nesting SUBSTITUTE Calls
FITS puts plain-English AI formulas inside Google Sheets. Say which word to drop. Get a clean column back. Free tier included.