Extract Text From Nth Occurrence of a Space in a Cell

Extract text from the nth occurrence of a space in a cell. This video looks at how to extract some text from another cell by looking for the 3rd occurrence of a space in the cell. The characters we want to extract occur after the 3rd space within the cell. By using the MID function along with FIND and SUBSTITUTE we can achieve this complex operation. Once written this will work for all the records in a list. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/