New answers tagged


This formula works: =REGEXREPLACE(A1,"(\s|^)([^,]*)","$1^$2^") Why does it work? (\s|^) searches for a space or the beginning of the string ([^,]*) searches for anything but a comma, as many times as possible The parentheses makes sure these 'capture groups' are available in the replace part; $1 is the first capture group, $2 is the ...

Top 50 recent answers are included