Feedback by UserVoice


My feedback

  1. 601 votes
    Sign in
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jedikangaroo supported this idea  · 
    An error occurred while saving the comment
    jedikangaroo commented  · 

    Absolutely. Today I needed a function to remove multiple unwanted characters, then replace spaces with dashes.
    Google Sheets:
    =REGEXREPLACE(REGEXREPLACE(C2,"[()\.&:\+',=?/]","")," +","\-")


    The Google sheets version will replace multiple spaces with a single dash. The Excel version will remove double dashes, but that is all.

Feedback and Knowledge Base