These are the most important Excel Text Functions you *NEED* to know

Excel Text Functions are important for cleaning up text data, extracting portions from cells or presenting combined results. In this concise video, learn the most important text functions and how to use them with 6 practical, everyday examples. The functions you will learn are: LEFT, RIGHT, MID, LEN, FIND, TEXTJOIN The examples are: Gender code (M for Male, F for Female) Extracting First name from a name Getting Last name from a name Converting a name to "Last name, first name" format All male staff names, comma separated Word count Timestamps: =========== 0:00 - Introduction 0:49 - The 6 text functions 5:56 - The 6 business examples 10:32 - Bonus (SUBSTITUTE) example for WORD COUNT Sample file: ========== https://chandoo.org/wp/important-text-functions/ Gear used in the video: =================== My mic, camera recommendations: https://www.amazon.com/shop/chandoo?listId=13T7P87OWEB7I