CODEWITHSUNDEEP
excelreplace
Martijn van den Bergh
Martijn van den Bergh

Reputation: 1554

Delete a character in excel until the first character

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

Answers (2)

Julli Schaf
Julli Schaf

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

Peter R
Peter R

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

Related Questions