This script for Google Spreadsheets allows you to generate slugs for your data such as might be used for creating unique urls.
Use it like this!
| # | A | B | C | 
|---|---|---|---|
| 1 | a | b | slug | 
| 2 | foo | baz bing | =slugify(A2:B4) | 
| 3 | bar | BAZ | |
| 4 | FOO | baz-bing | 
And you get this!
| # | A | B | C | 
|---|---|---|---|
| 1 | a | b | slug | 
| 2 | foo | baz bing | foo-baz-bing | 
| 3 | bar | BAZ | bar-baz | 
| 4 | FOO | baz-bing | foo-baz-bing-2 | 
Check for a dash surrounded by spaces to eliminate triple dashes:
eg: "Book - Dealer" becomes "book---dealer" instead of "book-dealer"
value = value.replace(/\s-\s/g, ' ');