how do i remove the comma from a google sheet?

You can use

=REGEXREPLACE(REGEXREPLACE(B222;"^\D+|\D+$"; ""); ",(\d+)\."; ".$1,")


  • REGEXREPLACE(...;"^\D+|\D+$"; "") will remove all non-digit chars at the start and end of the string, see demo
  • REGEXREPLACE(...;",(\d+)\."; ".$1,") will swap , and . around the number. See demo.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top