Learn how to find the last occurrence of a value in a column in Excel using XLOOKUP, INDEX, Find and Replace, and a VBA (User Defined 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
You convert latitude and longitude coordinates into an address because it is easier for humans to understand an address than coordinates. For instance, ‘123| Spreadsheet Planet
Learn how to switch first and last names with a comma in Excel using various methods such as Flash Fill, formulas, and VBA macro.| Spreadsheet Planet
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient.| Spreadsheet Planet
Discover 10 amazing time-saving hacks using the Ctrl + E shortcut in Excel. Learn how to utilize Flash Fill for tasks like unconcatenating data and converting text to UPPERCASE.| 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 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