Working with text скачать в хорошем качестве

Working with text

In this video I consider four distinct approaches to the problem of extracting a specific value from a somewhat random string of text. The methods applied, range from traditional, basic approaches through to advanced techniques yet to be released in mainstream Excel. One of the key objectives of adopting advanced techniques is to simplify the solution and, at the same time, reduce risk. The problem arose in the context of a question on the Chandoo Forum and the formulas presented here draw upon an answer provided by Bosco-yip.