How to delete alphanumerical characters (including blanks) up to a key word in a cell

Hi there,
I have imported a CSV file into an Excel sheet.
Some cells in a column contain a long string of alphanumerics including a keyword somewhere in the string.

I want to edit the cell contents to remove (delete) all alphanumerics (from the left-hand side in the cell) up to the selected keyword.

Points to be considered:
1. The number (count) of alphanumerics preceding the keyword may vary from cell to cell in the column
2. If necessary, it is acceptable to use a different formula for different keywords in different cells of the column.

For a better understanding to explain what I wish to execute, an Excel file showing "sample data" and manually changed "desired results" has been attached.

Thanks for your help in advance.
Regards
starter99

Hello and welcome to the forum.

This, in B11, returns your manually entered desired results:

=IFERROR(MID(B3,FIND("Mandat",B3),LEN(B3)),B3)

Copy down.

why not use built-in feature (Ex2016) PowerQuery (Get&Transform) ?

with your example

Hallo AliGW, 63Falcondude & sandy666,
Thanks a lot for your very fast response suggesting different solution alternatives.

I tried the formulas
=IFERROR(MID(B3,FIND("Mandat",B3),LEN(B3)),B3), suggested by 63Falcondude
and
=TRIM(MID(B5,FIND("Mandat",B5),100)), suggested by AliGW

but I am getting Excel's fomula error message.
I must be doing something very stupid but I can't seem to get to it what is it precisely?

I have tried these formulas under Excel "Office 2010" and "Office 2016" packages separately.
For example, under Excel 2016 the error message looks like:
180403 Test-checking results.xlsx

Adding Apostrophe to the formula as mentioned in the error message didn't help either.
I have never encountered such formula typing errors. It must be something very simple but what is it?

Any suggestions would be most welcome.
Thanks and regards
starter99

maybbe:
=WENNFEHLER(TEIL(B3;FINDEN("Mandat";B3);LÄNGE(B3));B3)
=GLÄTTEN(TEIL(B5;FINDEN("Mandat";B5);100))

Hallo AliGW, 63Falcondude & sandy666

Yes, this time it worked in a jiffy.
The difference was indeed using ";" instead of a "," and also the German equivalents of:
FIND = FINDEN
TRIM = GLÄTTEN
IFERROR = WENNFEHLER etc.

So both suggestions:
=WENNFEHLER(TEIL(B3;FINDEN("Mandat";B3);LÄNGE(B3));B3)
=GLÄTTEN(TEIL(B5;FINDEN("Mandat";B5);100))
worked flawlessly.

It should have occurred to me after getting suggestions in your first response itself that I am using the "Office 2010, Office 2016" packages localized for German-speaking countries.
I am sorry to have caused you additional work with your second mail.

Thanks a lot to all three of you for your quick and very effective help.
Best regards
starter99


PS: I would like to mark the problem as "solved" for this thread. However, I not sure if I am authorized to do it and if yes, how to do it after all. ;-))

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

You are welcome