CODEWITHSUNDEEP
regexgoogle-sheetsreplacegoogle-sheets-formulaarray-formulas
Ufuk AKÇAY
Ufuk AKÇAY

Reputation: 41

Remove a Specific Part of The String In The Cell

Table

Hi everyone,

I want to delete a specific part of the string in the cell. For example, I need a formula that will delete the "SEPETTE %5 İNDİRİM" string in the image.

Warning: the percentage changes in other cells. For example: 1-SEPETTE %5 İNDİRİM 2-SEPETTE %15 İNDİRİM 3-SEPETTE %30 İNDİRİM

Input:19,95 TLSEPETTE %5 İNDİRİM18,95 TL Output must be:19,95 TL18,95 TL

Upvotes: 1

Views: 62

Answers (1)

player0
player0

Reputation: 1

try in C1:

=ARRAYFORMULA(REGEXREPLACE(B1:B, "SEPETTE %\d+ İNDİRİM", " "))

Upvotes: 1

Related Questions