Formulas & functions
How a function works, with worked examples you can paste.
- LEFT and LEN Excel Formula: How to Use Them TogetherTo remove the last character from text in Excel, combine LEFT and LEN like this: =LEFT(A2,LEN(A2)-1). With the text in A2, LEN…
- Excel Trim a Range: Remove Extra Spaces from CellsTo trim a range in Excel, enter =TRIM(A2) beside the first value and fill the formula down; in Microsoft 365, you can…
- Excel Trim a Table: Clean Text or Remove Rows?To trim text inside an Excel table, add a column with =TRIM([@[Raw Name]]); to trim the table’s physical range, select it and…
- Excel Length of Service in Years and Months: FormulasTo calculate completed length of service in years and remaining months, enter the start date in A2 and the end date in…
- Excel LEN Function: Count Text Characters in CellsIn Excel for Microsoft 365, use the LEN function to count the characters in a cell: with text in A1, enter =LEN(A1).…
- Excel Length of Service Formula: Calculate Years and MonthsIf the start date is in B2 and the date to measure service through is in C2, use =DATEDIF(B2,C2,"y")&" years, "&DATEDIF(B2,C2,"ym")&" months".…
- Excel MID Function: Extract Text from the Middle of a CellExcel’s MID function extracts a chosen number of characters from the middle of a text string. Its syntax is =MID(text, start_num, num_chars):…
- Excel MID String: How to Extract Text by Position in CellsIn Excel, use the MID function to extract a specified number of characters from the middle of a text string: give it…
- Excel Middle Column Extraction: Formulas and ExamplesTo extract the middle column of a range in Excel for Microsoft 365, enter =CHOOSECOLS(A2:E100,ROUNDUP(COLUMNS(A2:E100)/2,0)) in an empty cell; it returns column…
- Excel MID Formula: Extract Text by PositionUse Excel’s MID function to extract a specified number of characters from a text value, starting at a position you choose. Its…
- Excel MID Function From the Right: Formulas That WorkNo: Excel’s MID function always counts characters from left to right. To take a fixed number of characters from the end of…
- Excel MID Function: Can It Return Variable-Length Text?Yes. Excel’s MID function can return a variable number of characters when you calculate its num_chars argument from the text, a cell…
- Excel LEFT Function: Extract Text from the Left SideTo extract characters from the beginning of a cell in Excel, use the LEFT function. If A2 contains the text ABC-104, the…
- Excel Power Query Left Function: How to Extract TextIn Excel Power Query, the equivalent of the worksheet LEFT function is Text.Start(text, count): it returns the first specified number of characters…
- LEFT Excel String Formula: Extract Text from the LeftIn Excel, use the LEFT function to return a chosen number of characters from the beginning of a text value. If A2…
- TEXTJOIN in Excel: Join Text from Arrays and RangesIn Excel, use TEXTJOIN to combine text from a range or array into one cell, with a delimiter such as a comma…
- TEXTJOIN Excel Unique Values: Formula, Sorting, and TipsYes. In Microsoft Excel for Microsoft 365, combine TEXTJOIN with UNIQUE to put distinct values from a range into one cell: enter…
- Text Join in Excel With a Comma: Formula and ExamplesTo join the values in cells A2:A10 with a comma and a space, use =TEXTJOIN(", ",TRUE,A2:A10). The formula skips empty cells, so…
- Excel CONCATENATE Formula With a Space: Clear ExamplesTo join two Excel cells with a space between them, use the ampersand operator and put a space inside quotation marks: =A2&"…
- Concatenate Excel Text With a Space Between ValuesYes. To concatenate text from cells A2 and B2 with one space between them, enter =A2&" "&B2; if A2 contains John and…
- Excel CONCATENATE With Commas: Formulas and ExamplesTo concatenate two Excel cells with a comma and a space between them, use =A2&", "&B2. For a range with several cells,…
- Concatenate Excel Formula With Comma: ExamplesTo concatenate two cells with a comma and a space between them, use =A2&", "&B2. For example, if A2 contains Maya and…
- Concat Excel Multiple Cells: Formulas, Spaces, and TipsTo concat (combine) multiple cells in Excel, use =CONCAT(A2:C2) to join the values in A2 through C2 without a separator, or use…
- Concat Excel Strings: Formulas and Practical ExamplesTo concatenate strings in Excel, join cell values with the ampersand operator (&) or use CONCAT; use TEXTJOIN when you want a…
- Excel CONCAT Formula: Combine Two Columns With a SpaceTo combine two columns in Excel, enter =CONCAT(A2," ",B2) in a blank cell, replacing A2 and B2 with the two cells in…
- Concat Excel Cells with Dates: Formulas, Fixes, and TipsTo concatenate text and a date in Excel, use the TEXT function to format the date before joining it to the text.…
- Concat Excel Columns: Formulas, Methods, and Fixes ExplainedTo concat Excel columns—that is, join values from separate cells into one—use the ampersand operator. With first names in A2 and last…
- Concat Excel Date Format: Keep Dates ReadableTo concatenate a date in Excel and keep it readable, convert the date to formatted text with TEXT first, then join it…
- Excel CONCAT Formula: Join Text and CellsExcel’s CONCAT function joins text from cells or text you type into a formula; it does not add spaces or punctuation unless…
- CONCAT in Excel: Join Text and NumbersYes. Excel’s CONCAT function can join numbers with text or other values, but it does not preserve a cell’s display formatting automatically.…