Excel Tips & Tricks: Format Text and Data for Analysis

As Analysts, we are often faced with large sets of data which may contain text fields. This text is not always in a format or structured in the way we need to use it—especially if we are trying to merge it with other data using VLOOKUP. The attached file contains some examples of formulas that you can use to manipulate the text or data into the format you need to continue with your analysis. &