Learn how to remove dotted lines in Excel worksheets. This guide covers removing page break lines, cell border lines, and gridlines in spreadsheets.| 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
By default, the cells in Excel have a specific row height and column width.| Spreadsheet Planet
There are occasions when we need to display different parts of a text string on different lines within the same Excel cell.| Spreadsheet Planet
When you work with Microsoft Excel, you might hear about something called ASCII.| Spreadsheet Planet
Learn how to break links to external references in Excel with two easy methods - using Edit Links option and Copy and Paste as Values method.| 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 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