Skip to content
- 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
- Excel Not Auto Filling Text? Fix the Common CausesIf Excel is not auto-filling text, check the feature you mean: turn on AutoComplete for suggestions based on entries already in a…Errors & fixes
- Excel Not Allowing Copy and Paste? How to Fix ItIf Excel is not allowing copy and paste, press Esc, select a normal cell, and try Ctrl+C followed by Ctrl+V; if it…Errors & fixes
- Excel Not a Number? Understand #NUM! and ISNUMBERIn Excel, “not a number” can refer to the #NUM! error, which means a formula cannot produce a valid numeric result, or…Errors & fixes
- Excel Copy and Paste Rows Into Columns: 3 Easy MethodsTo copy a row into a column in Excel for Microsoft 365 on Windows, select the row cells, press Ctrl+C, click a…How-to basics
- Excel IFS Error? Common Causes and FixesWith a score in A2, an IFS formula needs a final fallback if every test might be false: =IFS(A2>=90,"A",A2>=80,"B",TRUE,"F"). If Excel shows…Errors & fixes
- Excel IFS List: Syntax, Examples, and Common FixesExcel’s IFS function checks conditions in order and returns the result paired with the first condition that is TRUE. With a student’s…Formulas & functions
- Excel IFS for Blank Cells: Formulas and Common FixesTo make Excel’s IFS function return a result when a cell is blank, test for a blank first: with the value to…Formulas & functions
- Excel Not Working? Fixes for Common ProblemsIf Excel is not working, first save a copy of your workbook if you can, close and reopen Excel, and check whether…Errors & fixes
- Excel Not Responding: Should You Wait or Close It?Usually, wait briefly before closing Excel: the Not Responding message means Windows is not receiving a response from the app, but Excel…How-to basics
- COUNTIF in Excel: Count Cells That Equal a ValueWith values in A2:A10 and the value Apple to match, use =COUNTIF(A2:A10,"Apple") to count cells equal to Apple; if three cells contain…Formulas & functions