I am trying to delete all the text after a specific character in google sheets. I want to delete fro-CodePudding

Home > Net > I am trying to delete all the text after a specific character in google sheets. I want to delete fro

I am trying to delete all the text after a specific character in google sheets. I want to delete fro

Time：04-19

Example:

Guilty Blossoms White (Ladies 200ml EDP)(FP9001)(0015)(2E)

So the result would be:

Guilty Blossoms White (Ladies 200ml EDP)

CodePudding user response：

Try

=regexextract(A1,"[^\)] \)")

CodePudding user response：

I want to delete from EDP) onwards

try:

=REGEXEXTRACT(A1; ". EDP\)")