New answers tagged regex
0
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
