In this article, I’ll show you how to combine two string functions, MID() and FIND() to solve the problem of parsing structurally inconsistent data. I’m using Microsoft 365, but these ...