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 easily extract ZIP codes from addresses in Excel using different methods such as Flash Fill, RIGHT function, TEXTAFTER function, TEXTSPLIT and CHOOSECOLS functions, and MID function.| 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
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 reverse a text string in Excel using formulas and VBA scripts. This tutorial provides step-by-step instructions for both methods.| Spreadsheet Planet