Hello,
is there a possibility to get the character position of a shorter string from a larger one by formula?
In this example the short string in Column A starts from character 4 and goes to character 8 in the larger string (clomunB).
Just getting the first number would be enough, the rest isnīt hard but how do I get that the short one starts at position 4 of the large one?
ColumnA_____CoumnB_____ColumnC
defgh_______abcdefghij____4-8
Thank you for helping!
Bookmarks