Skip to content
- Excel SUBSTITUTE Multiple Values: Formulas and TipsTo substitute multiple values in Excel, nest the SUBSTITUTE function for each old-to-new text pair, or use a replacement list with a…Formulas & functions
- TRIM Excel Not Working? Fix Spaces That TRIM MissesIf TRIM appears not to work in Excel, the text may contain a character that TRIM does not recognize as a regular…Errors & fixes
- Excel: Calculate the Length of Time Between Two DatesTo find the elapsed number of days between two dates in Excel, subtract the earlier date from the later one: with the…How-to basics
- Excel Middle Align Shortcut: Center Text VerticallyIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, A, then M to apply Middle…How-to basics
- Excel MID Function: Extract Text From the Middle of TextExcel’s MID function extracts a chosen number of characters from the middle of a text value. With the full text in A2,…Formulas & functions
- Excel Not Letting You Copy and Paste? Fixes That WorkIf Excel will not copy and paste, first press Esc, select one ordinary cell, copy it with Ctrl+C, then select a blank…How-to basics
- Excel Not Letting You Filter? Fix the Common CausesIf Excel is not letting you filter, first select a cell in the data and choose Data > Sort & Filter >…Errors & fixes
- Excel Freeze Panes Not Working? Fix the SelectionIf Excel is not freezing the rows or columns you selected, click the cell immediately below the rows and to the right…Errors & fixes
- Excel Not Filling Sequential Numbers? Fix the SeriesIf Excel repeats a number instead of counting, enter the first two numbers, select both cells, and drag the fill handle down…Errors & fixes
- VLOOKUP Excel Using Two Spreadsheets: Steps and TipsYes. VLOOKUP can find a value in one Excel workbook and return related information from another; the workbooks do not have to…Formulas & functions
- Excel Not Dragging Down Numbers? Fix the Fill HandleIf Excel repeats a number instead of counting up, select the first two numbers in the pattern and drag the fill handle…Errors & fixes
- Excel MID Function: Extract Text From a CellIf the text you want to extract is in A2, use =MID(A2,5,5) to return five characters starting at the fifth character. For…Formulas & functions
- Excel MID and FIND Functions: How to Extract Text in ExcelWith the text INV-2026-047 in A2, use =MID(A2,FIND("-",A2)+1,4) to extract the year; the result is 2026. MID returns characters from a specified…Formulas & functions
- Excel MID Cell Reference: Extract Text from a CellTo extract characters from a cell in Excel, use the MID function with that cell as its first argument: =MID(A2,5,4). This returns…Formulas & functions
- Excel MID Function: Extract Text from a Cell’s MiddleTo extract characters from the middle of a cell in Excel, use the MID function, which takes a text value, a starting…Formulas & functions
- Excel Not Copying and Pasting Correctly? Fix ItIf Excel is not copying and pasting correctly, first press Esc, select the source cells again, press Ctrl+C, click one destination cell,…Errors & fixes
- VLOOKUP in Excel: Find Matching Values and Fix ErrorsTo find a matching value in Excel, use VLOOKUP with an exact-match setting. For example, if IDs are in A2:A6, department names…Errors & fixes
- XLOOKUP Excel Not Working? Fix Common Errors and CausesIf XLOOKUP is not working, first check that your Excel version supports it, then confirm the lookup and return ranges line up…Errors & fixes
- Concatenate Excel Files: Combine Workbooks Step by StepTo concatenate Excel files—combine their data into one workbook—use Power Query in Excel for Microsoft 365 on Windows: choose Data > Get…Formulas & functions
- TEXTJOIN in Excel Not Working? Common FixesIf TEXTJOIN in Excel is not working, first check that the function is spelled TEXTJOIN, your Excel version supports it, and your…Errors & fixes
- Text Join in Excel: Formulas and Practical ExamplesIn Excel for Microsoft 365, use TEXTJOIN to combine text from cells with a separator such as a comma, space, or line…Formulas & functions
- Concat Excel Different Sheets: Formulas and ExamplesTo concatenate values from different Excel sheets, use CONCAT with a reference to each sheet, such as =CONCAT(Jan!A2,Feb!A2). Add a text argument…Formulas & functions
- Concat Excel Cell Range: Join Cells With Simple FormulasWith the values to join in A2:A5, enter =CONCAT(A2:A5) to combine the range into one text string; for example, Mia, Leo, and…Formulas & functions
- Concatenate an Excel List: Join Values With DelimitersTo concatenate an Excel list into one cell, use TEXTJOIN: with the values in A2:A6, enter =TEXTJOIN(", ",TRUE,A2:A6). It joins the nonblank…Formulas & functions
- Excel CONCAT: Join Cell Values with a FormulaTo combine cell values in Excel, use the CONCAT function: with text in A2 and B2, enter =CONCAT(A2,B2) to join them with…Formulas & functions
- Excel Not Converting to Number? Fix Text-Formatted ValuesIf Excel is not converting a value to a number, first select the affected cells and use the warning icon that appears…Errors & fixes
- Excel Not Clicking the Correct Cell? Causes and FixesIf Excel is not clicking the correct cell, first press Esc, set the worksheet zoom to 100%, and click a clearly visible…How-to basics
- VLOOKUP in Excel: Steps, Examples, and Common FixesTo use VLOOKUP in Excel, put the value you want to find in a cell, then enter a formula such as =VLOOKUP(E2,$A$2:$C$5,2,FALSE)…Formulas & functions
- XLOOKUP Match Mode: Exact, Approximate, and WildcardsIn Excel, XLOOKUP’s match_mode is its fifth argument: use 0 for an exact match, -1 for an exact match or the next…Formulas & functions
- COUNTIF Excel: How to Reference Cells in CriteriaTo make COUNTIF use a cell as its criterion, put the cell reference in the second argument: with values in A2:A20 and…Formulas & functions