This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.
If I select a cell containing a formula, I know I can drag the little box in the right-hand corner …
excel excel-formulaHow do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and …
excel excel-formula excel-2010This seems like a simple Pivot Table to learn with. I would like to do a count of unique values …
excel excel-formula pivot-tableLets say I have one cell A1, which I want to keep constant in a calculation. For example, I want …
excel excel-formulaI need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string …
excel excel-formulaIs there an in-built function to check if a cell contains a given character/substring? It would mean you can …
excel excel-formulaI have an excel file with 10,000 rows in column A some values are the same. Example: A1 - P7767 A2 …
excel excel-formulaI want to get the content of a cell given its row and column number. The row and column number …
excel excel-formulaHow can I construct the following string in an Excel formula: Maurice "The Rocket" Richard If I'm using single quotes, …
excel excel-formulaHere's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address …
excel if-statement excel-formula excel-2013 excel-match