Formulas & functions
How a function works, with worked examples you can paste.
- Copy Numbers, Not Formulas in Excel: Step-by-Step GuideTo copy a formula’s current result without copying the formula in Excel, copy the cells, then use Paste Special and choose Values.…
- How to Copy in Excel Without Formulas: Keep ValuesTo copy the results of formulas without copying the formulas themselves in Excel for Microsoft 365 on Windows, select the cells, press…
- How to Copy an Excel Table With FormulasTo copy an Excel table and keep its formulas, select the table, press Ctrl+C, click a blank destination, and press Ctrl+V. Excel…
- How to Copy and Concatenate Text in Excel with FormulasTo combine text from two cells, put the values in A2 and B2, then enter =A2&" "&B2 in C2; if A2 contains…
- Copy and Paste Dates in Sequence in Excel: Step-by-StepTo create dates that increase in order, enter the first two dates in adjacent cells, select both, and drag the fill handle…
- Copy a Number in Excel Without Copying the FormulaTo copy a formula cell’s displayed number without copying its formula, copy the cell, select where it should go, then choose Home…
- How to Convert English to Hindi in Excel with FormulasTo convert English text in Excel to Hindi, enter the text in a cell and use Microsoft 365’s TRANSLATE function, or select…
- Concatenate in Excel with the Ampersand (&) OperatorTo concatenate text in Excel, enter an ampersand between the cell references you want to join. With a first name in A2…
- How to Concatenate a New Line in Excel with a FormulaTo join text from two Excel cells with a line break between them, enter =A2&CHAR(10)&B2 in a third cell, then select that…
- How to Concatenate in Excel and Add a DashTo join two cell values with a dash in Excel, enter =A2&"-"&B2 in a result cell, replacing A2 and B2 with the…
- How to Concatenate in Excel and Keep Cell FormattingTo concatenate values and keep dates, currency, percentages, or leading zeros readable, convert those values to formatted text with Excel’s TEXT function…
- How to Compute Numbers in Excel with Formulas and FunctionsTo compute numbers in Excel, enter a formula in a cell beginning with an equals sign, then use cell references and operators…
- Compute Number of Years in Excel: Formulas and ExamplesTo calculate completed years between two dates in Excel, enter the start date in A2 and the end date in B2, then…
- How to Concatenate a Long List in Excel with TEXTJOINTo concatenate a long list in Excel into one cell, use TEXTJOIN: with your items in A2:A1000, enter =TEXTJOIN(", ",TRUE,A2:A1000) in an…
- How to Compare Hours in Excel With Formulas and FormattingTo compare two times in Excel, enter them as real time values and use a comparison formula such as =IF(A2>B2,"A is later",IF(A2<B2,"B…
- Compare Two Dates in Excel: Formulas and FormattingTo compare two dates in Excel, enter this formula in a result cell: =IF(A2<B2,"A is earlier",IF(A2>B2,"A is later","Same date")), assuming the dates…
- Compare Data in Excel With VLOOKUP: A Step-by-Step GuideTo compare two lists in Excel, use an exact-match VLOOKUP to check whether each item in one list appears in the other.…
- How to Combine Names in Excel With a Formula EasilyTo combine first, middle, and last names in Excel, put them in separate columns and enter =TRIM(A2&" "&B2&" "&C2) in the result…
- Combine Names in Excel: Join Two Cells with a FormulaWith a first name in A2 and a last name in B2, enter =A2&" "&B2 in another cell to combine them with…
- How to Combine Names in Excel with Formulas and Flash FillTo combine first, middle, and last names in Excel, put them in A2:C2 in that order, then enter =TEXTJOIN(" ",TRUE,A2:C2) in D2.…
- Combine Day, Month, and Year in Excel with a Date FormulaTo combine a day, month, and year from separate cells into a real Excel date, use the DATE function. If the day…
- How to Close the Formula Bar in Excel on Any DeviceTo close—or hide—the formula bar in Excel, open the View tab and clear the Formula Bar checkbox. In Excel for Microsoft 365…
- How to Clear an A to Z Filter in Excel and Show All RowsTo show all rows hidden by a filter in Excel for Microsoft 365 on Windows, open the filtered column’s drop-down arrow and…
- Clear Sort A to Z in Excel: Restore Your Data OrderTo undo an A-to-Z sort in Excel, press Ctrl+Z right away (Command+Z on Mac). If you have already made other changes, Excel…
- How to Change the Year in an Excel Calendar FormulaTo change the year in an Excel calendar formula, update the year cell the calendar refers to; the dates should recalculate automatically.…
- Proper Case in Excel: Change Names with the PROPER FunctionTo change names to proper case in Excel, enter =PROPER(A2) in a blank column beside the first name, then fill the formula…
- How to Change Name Format in Excel: Formulas and Flash FillTo change names such as Ava Chen to Chen, Ava in Excel, enter a pattern with Flash Fill or use a formula…
- Change Caps Lock to Lowercase in Excel with a FormulaTo change text that is already in all caps to lowercase in Excel, enter =LOWER(A2) in a blank cell beside it, then…
- How to Capitalize Words in Excel: Shortcuts and FormulasExcel has no built-in keyboard shortcut that directly changes the case of selected text. To capitalize the first letter of each word,…
- Capitalize in Excel Without a Formula: 3 Easy MethodsTo capitalize text in Excel without a formula, use Data > Flash Fill: type the capitalization you want beside the first source…