The TRIM function removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.| support.microsoft.com
How to use the IF function in Excel to make logical comparisons between data values.| support.microsoft.com
Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.| support.microsoft.com
Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.| support.microsoft.com
Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.| support.microsoft.com
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.| support.microsoft.com
How to use the HLOOKUP function in Excel to locate specific data from a row in a table.| support.microsoft.com
How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.| support.microsoft.com
Syntax: EXACT(text1, text2)| support.microsoft.com
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.| support.microsoft.com
Learn more about the SEQUENCE function, which allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. SEQUENCE is in a class of functions called dynamic arrays.| support.microsoft.com
Learn about the RANDARRAY function for creating arrays of random numbers between 0 and 1. RANDARRAY is in a class of functions called dynamic arrays.| support.microsoft.com
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.| support.microsoft.com
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.| support.microsoft.com
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.| support.microsoft.com
Syntax: COUNTA(value1,value2,...)| support.microsoft.com
Syntax: OFFSET(reference, rows, cols, [height], [width])| support.microsoft.com
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.| support.microsoft.com
Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.| support.microsoft.com
The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.| support.microsoft.com
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.| support.microsoft.com
How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.| support.microsoft.com
Use a LAMBDA function to create custom, reusable functions and call them by a friendly name. The new function is available throughout the workbook and called like native Excel functions.| support.microsoft.com
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.| support.microsoft.com
How to use the INDEX function in Excel to return a value or reference to a value within a table or range.| support.microsoft.com
How to use the FILTER function in Excel to filter a range of data based on criteria you define.| support.microsoft.com
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.| support.microsoft.com