Log in
x
or
x
x
Register
x

or

Excel Tips: Calculation & Formulas > User Defined Functions

Edit

Edit > Change Cell Content

How to add space between characters or every digit in Excel?

How to add space between first name and last name in Excel?

How to insert spaces before capital letters in excel?

How to reverse text string or words order in Excel?

How to reverse text strings within cells in Google sheet?

How to scramble letters in words in Excel?

Edit > Combine

How to combine cells into a cell with space, commas and semicolon in Excel?

How to concatenate cells ignore or skip blanks in Excel?

How to concatenate only visible cells in Excel?

How to concatenate unique values in Excel?

How to easily concatenate text based on criteria in Excel?

How to reverse the text to column function in Excel?

Edit > Convert

How to convert cardinal number to ordinal number in Excel?

How to convert currency to words text in Excel?

How to convert decimal degrees to degrees minutes seconds in Excel?

How to convert formula to text string in Excel?

How to convert text strings to formulas in Excel?

How to quickly convert currency numbers to words in Excel?

How to quickly convert date to words in Excel?

How to spell out or convert numbers to English words in Excel?

Edit > Delete & Clear

How to remove all brackets from string in a range in Excel?

How to remove all characters after the first/last space from cells in Excel?

How to remove all punctuation marks (comma, quotation, apostrophe) from cells?

How to remove duplicate characters or words in string of a cell?

How to remove first comma from text string in Excel?

How to remove first or last n characters from a cell or string in Excel?

How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?

How to remove leading zeros from alphanumeric text string in Excel?

How to remove letters from strings/numbers/cells in Excel?

How to remove numbers from cells which containing texts and numbers in Excel?

How to remove numbers from text strings in Excel?

How to remove only text from cells that containing numbers and texts in Excel?

How to remove some special characters from string in Excel?

Edit > Extract

How to extract actual addresses from hyperlinks in Excel?

How to extract bold text only from a list in Excel?

How to extract capital letters or words starting with capital letter from text strings?

How to extract domain name from URL in Excel?

How to extract file extension from worksheet?

How to extract first / last / nth word from text string in Excel?

How to extract first letter of each word from cell?

How to extract initials from names in Excel?

How to extract text based on font color from a cell in Excel?

How to extract text only from alphanumeric string in Excel?

How to quickly extract email address from text string?

How to quickly extract filename from full path in Excel?

Edit > Fill cell content

Get and insert the created time and last modified time in cells

How to generate random character strings in a range in Excel?

How to generate random weekday or weekend date in Excel?

How to get and insert the last modified user name in Excel?

How to get current time zone and display in cell in Excel?

How to get current workbook name in Excel?

How to get the next sheet name in Excel workbook?

How to insert last saved timestamp into worksheet cell in Excel?

How to insert random (integer) numbers between two numbers without repeats in Excel?

How to reference tab name in cell in Excel?

How to reference worksheet by index number instead of name in Excel?

Edit > Split

How to separate text and numbers from one cell into two columns?

How to split / separate alphanumeric strings into two columns in Excel?

How to split by delimiter and transpose cells in Excel?

How to split text into separate columns by capital letter in Excel?

Edit > Others

How to convert carriage return to comma in Excel?

How to copy source formatting of the lookup cell when using Vlookup in Excel?

How to find all combinations that equal a given sum in Excel?

How to hide rows based on cell color in Excel?

How to quickly find the position of first letter (alpha) from string in Excel?

How to quickly find the position of first uppercase in Excel text string?

How to replace accented characters with regular characters in Excel?

How to select cells randomly in Excel?

How to transpose data from column into one single cell in Excel?

Insert

How to check if a pivot table exists in a workbook?

How to display table or pivot table name in a cell in Excel?

How to extract actual addresses from hyperlinks in Excel?

How to generate all prime numbers between two given numbers in Excel?

How to get list of sheets names in Google sheets?

Format

How to convert date to ordinal date format in Excel?

How to determine and identify the background color index of cells in Excel?

How to display row height or column width in cells?

How to format number as ordinal (1st 2nd 3rd ) in Excel?

How to highlight / conditional formatting cells with formulas in Excel?

How to highlight cells with external links in Excel?

How to pad IP address with zero in Excel?

Data

How to check if a sheet exists in a workbook?

How to check if the number is prime number in Excel?

How to display / show auto filter criteria in Excel?

How to filter cells with comments in Excel?

How to filter cells with formulas in Excel?

How to filter data by multiple colors in Excel?

How to filter rows based on cell color in Google sheet?

How to sort cells by last character or number in Excel?

How to sort data by case sensitive in Excel?

How to sort numbers with text/letter prefix or suffix in Excel?

How to sort numbers within a cell in Excel?

How to sort or filter data by strikethrough in Excel?

Calculation & Formulas

Calculation & Formulas > Statistic

How to calculate average without max and min values in Excel?

How to count / sum cells based on the font colors in Excel?

How to count / sum strikethrough cells in Excel?

How to count and sum cells based on background color in Excel?

How to count cells match to either X or Y in Excel?

How to count if cells contain any date/data in Excel?

How to count merged cells in selected range in Excel?

How to count number of cells with comments in Excel?

How to count the number of characters, letters and numbers in cell?

How to count the number of weekends/weekdays between two dates in Excel?

How to count the number of words in a cell or a range cells in Excel?

How to find the maximum / minimum absolute values in Excel?

How to quickly average visible/filtered cells only in Excel?

How to quickly count if cells are equal to x or y in Excel?

How to quickly count visible or filtered cells only in Excel?

Calculation & Formulas > Math

How to count and sum cells based on background color in Excel?

How to quickly sum every other or nth row/column in Excel?

How to round range of numbers to even in Excel?

How to sum / count bold numbers in a range of cells in Excel?

How to sum all digits in a number in Excel?

How to sum cells with text and numbers in Excel?

How to sum entire column except header/first row in Excel?

How to sum numbers in brackets only in Excel?

How to sum only filtered or visible cells in Excel?

How to sum or adding numbers in a single cell in Excel?

Calculation & Formulas > Look for a Value

How to apply negative vlookup to return the value in left of the key field in Excel?

How to lookup value return multiple corresponding values in Excel?

How to return multiple lookup values in one comma separated cell?

How to vlookup and concatenate multiple corresponding values in Excel?

How to vlookup and return background color along with the lookup value in Excel?

How to vlookup and return multiple values without duplicates in Excel?

How to vlookup to return multiple values in one cell in Excel?

How to VLOOKUP value case sensitive or insensitive in Excel?

Calculation & Formulas > Date or Time

How to calculate age before 1/1/1900 in Excel?

How to calculate Easter date in Excel?

How to check if a year is a leap year in Excel?

How to count the number of weekends/weekdays between two dates in Excel?

How to determine if a date falls between two dates or weekend in Excel?

How to get end of month date in Excel?

Calculation & Formulas > Others

How to apply same formula to multiple cells in Excel?

How to automatically increase letter by one to get the next letter in Excel?

How to calculate compound interest in Excel?

How to extract cell reference from formulas in Excel?

How to find nth occurrence (position) of a character in text string in Excel?

How to find the first, last or nth occurrence of a character in Excel?

How to find the position of the first lowercase letter from text strings?

How to get the cell value based on row and column numbers in Excel?

How to quickly get address of named range in Excel?

Others

How to check if a folder path exists in Excel?

How to convert column letter to number or vice versa in Excel?

How to convert comments to cell contents in Excel?

How to easily extract comments contents in Excel?

How to play a sound if a condition is met in Excel?

How to use/reference value from previous worksheet in Excel?