• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format text removing spaces and replacing for hyphens


I need to replace old URLs for new ones, but i need capture text from de field called NOME (Name in english). For instance in the column A:

Roupa PJ Masks - Blusa PJ Masks - Corujita - Cinza - Malwee

Then i need to format like this in a new column:


So the requirements:

1. Remove all trailing spaces, spaces in general
2. Keep just one hyphen between words
3. Lower case all new url

I would appreciate help. Thanks in advance.