I would like help to create a formula that can take a string of text like this:
Crafter's Companion 5in x 7in Die-Cut Card Bases & Envelopes Rectangular Aperture | Set of 20
and converts it to this:
It's for a site URL so needs to be free of special characters and spaces and instead have dashes. Note that eg "(space)|(space)" converts to one dash "-" rather than three dashes "---"
I've tried SUBSTITUTE but I can only specify one character at a time.
Would prefer a formula to a VBA script as it's for non-excel-savvy users.