• 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

    Hui...

  • 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

Hi,

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:

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

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

NEW URL
roupa-pj-masks-blusa-pj-masks-corujita-cinza-malwee

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.
 
Top