Hi

Got another one to do

Substitute any , or . with nothing, and any spaces with a -.

So far have =LOWER(SUBSTITUTE(Sheet1!C2," ","-"))

which changes the spaces with dashes, how now to delete the , and .

example text would be

abc, vol2. 10c

need it to look like abc-vol2-10c