Hello Excelperts,
I find myself in a bit of a conundrum and looking for your help and expertise to learn how to pull a substring from a cell of variable length string.
From the transcript column A1, I have variable length transcript string, what I am looking to extract is the name of the...