I have the following text: “1-1 / 3 cups of warm water 2 tablespoons of white coniferous seed bread 1/4 cup of molten honey” - I want to replace all spaces followed by a number with “ç” (1)
Usually regex in GSheets uses parentheses to form capture groups: when I use =REGEXEXTRACT(B3,"(\s)\d") , I get one space as I should, but if I use =REGEXREPLACE(B3,"(\s)\d","ç") , I get Ingredients:ç-1/3 cups warm WATERç tablespoons white CHIA SEED MEALç/4 cup melted HONEY
Does anyone know how to get Google to replace only space, so I get the output as follows: Ingredients:ç1-1/3 cups warm WATERç2 tablespoons white CHIA SEED MEALç1/4 cup melted HONEY ? Thanks a ton!
(1) I use "ç" to later use the "SPLIT" command to split into each "ç".
source share