In fact, you missed most important part of info in first message. Now it’s more clear. please disregard part about sub and regex
Your goal is not to remove chars, you need to debug why blank values counted by formula as non-blank. Usually it’s lookups, but not limited to.