Google sheet: Replace (_) with (Empty space) in the selected cells-CodePudding

Home > database > Google sheet: Replace (_) with (Empty space) in the selected cells

Google sheet: Replace (_) with (Empty space) in the selected cells

Time：11-08

I need to replace the (_) in the first range (Red rectangle) into a SPACE in the second range (Green rectangle). How can i do that ? thanks in advance ❤️

CodePudding user response：

try like this:

=INDEX(SUBSTITUTE(A1:A10; "_"; " "))

CodePudding user response：

This would also works:

=ArrayFormula(REGEXREPLACE(A1:A,"_"," "))

Page link：https//www.codepudding.com/database/602424.html

Prev:EXCEL/Google Sheets. Best way to SUM multiple VLOOKUP?

Next:Trying to label rows in Google Sheets where there are duplicate values in one column in order of of

Tags：

google-sheets

Links：
CodePudding