Within this video I run through 6 Excel formulas that can be used in day to day work that should hopefully make your life easier! Formulas on the list are as follows: 1. Left Right Mid Find 2. Concatenate 3. Proper 4. Vlookup 5. Countif 6. If statement Formula used to extract the name in the middle of the email string, you'll need to amend the cell references to whichever cell you're trying to extract the data from: =MID(A2,FIND(".",A2,1)+1,(FIND("@",A2,1)-FIND(".",A2,1)-1)) If you have any questions drop them in the comments below or email: Will-aat@ Link to my full library of videos: Thank you for watching.