How to compare fields character by character?

Question

excel

There is field A 333000 and more B 333999.
How to get the common part 333?

Answer 1

Since there are no cycles in Excel, you need to make a comparison in additional fields: at the beginning of the first characters, then the first two, three, etc. Then find the maximum number of matching characters and extract the substring from the searched string.