CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
dansumption
dansumption

Reputation: 83

SUBSTITUTE within ARRAYFORMULA in Google Sheets

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?

Upvotes: 1

Views: 5172

Answers (1)

ADW
ADW

Reputation: 4247

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

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

Upvotes: 4

Related Questions