Learn how to remove leading spaces in Excel using five different techniques, including the TRIM function, Flash Fill, and Find and Replace.| 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 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 remove leading zeros in Excel using different methods - custom number format, text format, and formulas,. Also, remove a fixed number of zeros with ease.| 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 easily remove the last digit from your data in Excel using built-in functionalities, LEFT/LEN functions, and the Flash Fill feature.| Spreadsheet Planet
Learn how to generate random letters in Excel for sample text, testing formulas, or security keys and passwords. Use CHAR and RANDBETWEEN functions to create uppercase, lowercase, or mixed strings.| Spreadsheet Planet
Learn how to change all caps to lowercase, except the first letter, in Excel (using the PROPER, LOWER, RIGHT, and LEFT 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
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 the first character from a data set in Excel using different methods such as Flash Fill, built-in functions, and Text to Columns| 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 5 methods to separate names in Excel, including Text-to-Columns, Flash Fill, Find and Replace, Formula, and Power Query.| Spreadsheet Planet
Learn how to easily convert text to sentence case in Excel using various methods, including Flash Fill and formulas.| Spreadsheet Planet
Learn how to concatenate strings in Excel with line breaks using the ampersand operator (&), CONCATENATE function, and TEXTJOIN function| 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