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
Bookmarks