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
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
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
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum every nth value in a range of values.| support.microsoft.com
Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com
Lists all Excel functions by their category, such as Logical functions or Text functions.| support.microsoft.com
A complete list of all Excel functions in alphabetical order.| support.microsoft.com
You can use error checking to detect errors in formulas. The rules don't guarantee error-free worksheets, but they can help find common mistakes. Errors can include: Cells containing formulas that result in an error, inconsistent calculated column formula in tables, cells containing years represented as 2 digits, numbers formatted as text or preceded by an apostrophe, formulas inconsistent with other formulas in the region, formulas which omit cells in a region, unlocked cells containing form...| support.microsoft.com
Learn how to use Excel shortcut keys for the US keyboard layout.| 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