Feedback by UserVoice

jedikangaroo

My feedback

  1. 601 votes
    Sign in
    (thinking…)
    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,"[()\.&:\+',=?/]","")," +","\-")

    Excel:
    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(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