This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.

Shortcut to Apply a Formula to an Entire Column in Excel

If I select a cell containing a formula, I know I can drag the little box in the right-hand corner …

excel excel-formula
Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and …

excel excel-formula excel-2010
Simple Pivot Table to Count Unique Values

This seems like a simple Pivot Table to learn with. I would like to do a count of unique values …

excel excel-formula pivot-table
How to keep one variable constant with other one changing with row in excel

Lets say I have one cell A1, which I want to keep constant in a calculation. For example, I want …

excel excel-formula
Return empty cell from formula in Excel

I need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string …

excel excel-formula
Check whether a cell contains a substring

Is there an in-built function to check if a cell contains a given character/substring? It would mean you can …

excel excel-formula
Excel compare two columns and highlight when found

I have an excel file with 10,000 rows in column A some values are the same. Example: A1 - P7767 A2 …

excel excel-formula
Get content of a cell given the row and column numbers

I want to get the content of a cell given its row and column number. The row and column number …

excel excel-formula
How to create strings containing double quotes in Excel formulas?

How can I construct the following string in an Excel formula: Maurice "The Rocket" Richard If I'm using single quotes, …

excel excel-formula
If two cells match, return value from third

Here'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