I’ve seen many solutions for finding the longest common substring (LCS) or longest shared text between two strings in other programs or languages, but not one that uses formulas in Excel. Posting my own solution here. Please feel free to add suggestions for how I could improve this formula — Sarr seems particularly “bloated”.

I’ve seen many solutions for finding the longest common substring (LCS) or longest shared text between two strings in other programs or languages, but not one that uses formulas in Excel. Posting my own solution here. Please feel free to add suggestions for how I could improve this formula — Sarr seems particularly “bloated”.

I’ve seen many solutions for finding the longest common substring (LCS) or longest shared text between two strings in other programs or languages, but not one that uses formulas in Excel. Posting my own solution here. Please feel free to add suggestions for how I could improve this formula — Sarr seems particularly “bloated”.