Can I use a formula to find a word in a cell and if the word is present delete the first hyphen (Without AI Please)
Ok for eg I get a list daily where most are set up as:
Type - NAME - Subject
But some are set up as:
Type - Subtype - NAME - Subject
And I need the formula to find any with the Subtype and remove the first hyphen from them before continuing with the rest of the formulas I have set up for contingencies such as someone put a : instead of a hyphen, or an en/em dash etc. I can’t make it delete the first if it finds 3 hyphens because sometimes the NAME section is hyphenated and it would throw a different formula off.
I did work out a long formula that got the job done but when I sorted the data by another column (TYPE) it threw off the string of formulas (eg it’d be A2+Sheet2A2 and when sorted would be A2+Sheet2A57)
Posted Aug 27, 2026, 12:58 PM UTC