'I am trying to delete all the text after a specific character in google sheets. I want to delete from EDP) onwards
Example:
Guilty Blossoms White (Ladies 200ml EDP)(FP9001)(0015)(2E)
So the result would be:
Guilty Blossoms White (Ladies 200ml EDP)
Solution 1:[1]
Try
=regexextract(A1,"[^\)]+\)")
Solution 2:[2]
I want to delete from EDP) onwards
try:
=REGEXEXTRACT(A1; ".+EDP\)")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mike Steelson |
| Solution 2 | player0 |