I am using this:
=LOWER( SUBSTITUTE( A1, " ", "-"))
to replace spaces in a sentence with dashes and make it all lowercase. Occasionally there is a dash in the original cell so I end up with three dashes ---
Currently
One - Short Sentence
becomes
one---short-sentence
but I would like it to become
one-short-sentence
Currently I do another substitute to replace --- with - to another column but I would love to do it all in one formula and save myself a column. Is that possible?
=LOWER( SUBSTITUTE( A1, " ", "-"))
to replace spaces in a sentence with dashes and make it all lowercase. Occasionally there is a dash in the original cell so I end up with three dashes ---
Currently
One - Short Sentence
becomes
one---short-sentence
but I would like it to become
one-short-sentence
Currently I do another substitute to replace --- with - to another column but I would love to do it all in one formula and save myself a column. Is that possible?