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 find the position of the last space in a text string in Excel using a formulas or a VBA custom function.| Spreadsheet Planet
Learn how to extract numbers from mixed text in Excel. Whether the number is at the beginning, end, or middle of the text, these formulas and functions will help you clean your data.| 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 reverse concatenate (Opposite of Concatenate) in Excel with these 5 techniques, including using Flash Fill and Text to Columns.| Spreadsheet Planet
Learn how to select alternate columns in Excel using traditional and VBA methods, and how to highlight, delete, or select every Nth column.| Spreadsheet Planet
Learn how to find the closest match in Excel using the INDEX-MATCH or XLOOKUP formulas (with examples for finding the nearest value).| 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 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
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
Learn 5 methods to separate names in Excel, including Text-to-Columns, Flash Fill, Find and Replace, Formula, and Power Query.| 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