When it comes to data analysis in Excel or any other tool, everything can fall apart if you're data isn't stored in a consistent format. Often, the data you need is hidden in plain sight inside other fields. An example would be first name and surname which might be embedded in an email field just waiting to be extracted if you can just work out the pattern. There are lots of formulas in Excel tailored to extracting exactly what you need and I'm going to show you 8 of them in this video. Whilst there are some up and coming new ones, the classics, and the ones you will find used in 99% of sheets where text manipulation is applied are LEFT MID RIGHT SUBSTITUTE SEARCH CONCATENATE LEN TRIM ...and we will cover ALL of these in this video with detailed examples.