Syntax:
REGEXREPLACE(text, regular_expression, replacement)
String:
Ibu memasak ayam goreng di dapur.
Formula:
REGEXREPLACE(A1;"(Ibu |memasak |goreng )";"")
Hasil:
ayam di dapur.
REGEXREPLACE(text, regular_expression, replacement)
Ibu memasak ayam goreng di dapur.
REGEXREPLACE(A1;"(Ibu |memasak |goreng )";"")
ayam di dapur.