If I understand what you’re asking (and that’s a very big “IF”), you want something like this:
In other words, find the longest common initial substring of
and then return how many characters
A2 has beyond that. This would be a terrible kludge if it worked, and it doesn’t, because Excel doesn’t let you nest that deep,
and you would need to go up to … what, 42? I know that some German words are very long.
(I did test the above formula by deleting the first two lines and starting with
This clearly is something that should be done in VBA, and it would be a struggle for me to write it, so I’ll ask the rest of the SU community to give the VBA answer.
(Or, András, if this isn’t what you want, explain what you do want more clearly.)