Programming to conjugate verbs

Please see attached book, note you will have to enter a case for accented and un-accented words!

How about this (used squiggler47 attachment and add orange cells)...

Define somewhere list of all prefixes:

I'm assuming that all the endings may not be 2 letters long!

Here is 2nd attempt...

So far it fails only for words with repeating (like haha in hahahaha).

Hope there is no much those words...

I also assumed the chance of repeated letters!

Hi DJakob,

my example is made to include several words.. Only you need to add few columns and extend formula... So you can write few words in each cell.

But you will have lot of problem with that:

1st. If you don't define word you'll get #N/A
(which may be fine and tell you to define word in a A and B column)

But next things become harder

2nd you can not define several instance for same word.. For example you can not have:

Please Login or Register  to view this content.

because it would always look for 1st defined instance and can not determine what you wanted to say.

It's the reason why Google translator can not be specific (or it's too hard to make it) when translating... I know that for Czech because it's similliar for Croatian.

I když bylo jasné

P.S. It's not bad to see that this give you best fit... So in example delat change to delam, and not at to atc