SUBSTITUTE within ARRAYFORMULA in Google Sheets

1
votes

I am trying to perform a text replacement over multiple cells. I'm sure I can do this using ARRAYFORMULA, but I'm not sure how to feed SUBSTITUTE with an array rather than a single value.

I have tried using =ARRAYFORMULA(SUBSTITUTE(A1:A, '&', '&')) but this gives a formula parse error.

What is the correct formula to use?

1
google-sheetsgoogle-sheets-formula

1 Answers

3
votes

You need to use the double quotation marks " instead of the single quotation marks '

=ARRAYFORMULA(SUBSTITUTE(A1:A, "&", "&"))