Reputation: 1554
I have data in a column that is structured like this:
s1 ma(av) course title
And i want to delete everything up till and including the ")" BUT sometimes in my data something like this occures:
s1 ma(av) course title(extra info)
So if i do a find and replace with this "*)" it deletes everything. Is there a way to delete everything up until the first ")"?
The result should be:
course title(extra info)
Thanks in advance
Upvotes: 2
Views: 43
Reputation: 92
Unfortunately my Excel is in german only, but im sure you can translate the functions.
This should work:
=TEIL(A1;FINDEN(")";A1)+2;55)
The "+2" deletes the following whitespace.
Upvotes: 2
Reputation: 36
you can specify the number of characters you want to remove from the left string by changing the Number 10 in the formula
=RIGHT(A1;LEN(A1)-10)
Upvotes: 0