Learn how to remove middle names from full names in Excel using Flash Fill, Find and Replace, Text to Columns, TEXTSPLIT Function, and more.| Spreadsheet Planet
Learn how to extract the last word in Excel using five different methods, including Flash Fill, Find and Replace, Power Query, & TEXTAFTER function.| Spreadsheet Planet
We often need to work with names in Excel. A lot of times we might need to work with a certain part of names in a list.| Spreadsheet Planet
Learn how to combine two columns in Excel with space or comma using six simple methods. From using the ampersand operator to the Flash Fill feature, this tutorial covers it all.| Spreadsheet Planet
Learn how to switch first and last names with a comma in Excel using various methods such as Flash Fill, formulas, and VBA macro.| Spreadsheet Planet
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient.| Spreadsheet Planet
Learn how to generate random names in Excel using TEXTJOIN, XLOOKUP, and RANDBETWEEN functions.| Spreadsheet Planet
Learn how to quickly remove extra spaces before text in Excel using functions, formulas, VBA code, and more. Get rid of leading spaces hassle-free!| Spreadsheet Planet
Learn how to extract text after the space character in Excel using formulas, VBA code, and Text to Columns (step-by-step instructions).| Spreadsheet Planet
Learn how to split one column into multiple columns in Excel using the 'Text to Columns' feature (step-by-step instructions)| Spreadsheet Planet
Learn how to separate address in Excel using Text-to-columns, Flash Fill, and LEFT, RIGHT, and MID functions. Split addresses into street, city, state, and zip code columns.| Spreadsheet Planet
Learn 3 methods to remove text after a specific character in Excel, including Find and Replace, Formulas, and VBA. Also, remove text after the nth instance of a character.| Spreadsheet Planet
Learn how to remove specific characters from strings in Excel using functions, formulas, and features.| Spreadsheet Planet
There might be some cases where you may want to remove the last four characters from the dataset in Excel.| Spreadsheet Planet
Learn how to remove commas in Excel, whether from numbers or text strings. Use Find and Replace, formulas, or the Text to Columns wizard.| Spreadsheet Planet
Learn 4 easy ways to add text to the beginning or end of all cells in Excel using ampersand, CONCATENATE, Flash Fill, and VBA.| Spreadsheet Planet