Forum Discussion
Lambda Formula for Replacing Substrings
Cosmetic comment, in current formula I'm not sure why do you need OFFSET, empty string is enough.
But before writing the formula (or Power Query, or VBA) it's better to define the logic what shall be removed. For example, single character - is that the character surrounded by space or any of punctuation character s(which ones) or start/end of the paragraph. What shall be removed in such case.
Similar for other cases.
Having such logic in any text-like notation it'll be easier with formula.
SergeiBaklan cosmetic commentary, well received!
Empty string "" produces the same result as offset, so kudos for the simplification 🙂
Re: defining the logic behind the removal, is there a way I could use a formula to specify to only remove these characters (and character sets) when they occur as the final word or standalone character in a cell?
I've tried denoting a space before " " and after " ", such as " "A" " but to no avail