how do i remove the comma from a google sheet?

June 2, 2022 June 2, 2022 / 1 minute of reading

You can use

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

Details

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.