Learn how to generate random names in Excel using TEXTJOIN, XLOOKUP, and RANDBETWEEN functions.| 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 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
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