Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
  • Formulas
  • Charts
  • VBA / Macros

Formulas

How to Merge First and Last Name in Excel (2 Easy Ways)

Combine Names using Flash Fill with capitalized first letter

When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient. This is because it makes filtering and querying easier. However, there may …

Read more

How to Add Days to a Date in Excel

Add days to date using the DATE function

You may have come across situations where you needed to add a certain number of days to a date. Say, you have a company policy that allows you to dispatch …

Read more

How to Remove Commas in Excel (from Numbers or Text String)

Numbers with comma

Commas serve multiple purposes when working with spreadsheets. They make numbers more readable. For example, the number 1,452,346 is much clearer than the number 1452346. Commas also help delimit related …

Read more

How to Insert Square Root Symbol in Excel (5 Easy Ways)

Insert Square Root symbol using UNICHAR formula

Every software in the Microsoft Office package comes with its own purpose and application. Just like MS Word was built for word processing, MS Excel has been created to work …

Read more

How to Calculate Standard Error in Excel (Step-by-Step)

Standard Error Value from Data Analysis Toolpak

Most people use spreadsheets software such as Microsoft Excel to process their data and carry out their analysis tasks. When performing an analysis of data, a number of statistical metrics …

Read more

How to Filter as You Type in Excel (With and Without VBA)

Filter formula in cell E4

Excel has some powerful Filter options (with inbuilt filter, advanced filter, and now the FILTER function in Office 365). But none of these options actually filter as you type (i.e., …

Read more

How to Subtract Multiple Cells from One Cell in Excel

Formula to subtract columns from a cell

If you need to subtract a single value from a range of cells at the same time, there are multiple ways can do this in Excel. For example, suppose you …

Read more

How to Select Every Other Cell in Excel (Or Every Nth Cell)

Select every other cell in a column in Excel

If you’ve ever tried selecting alternate cells or cells in a particular pattern in Excel, you would know that this is not as easy as it seems. Well, if it …

Read more

SUMPRODUCT vs SUMIFS Function in Excel

SUMIFS Vs SUMPRODUCT

The SUMPRODUCT function was always the go-to function for finding conditional sums, till the time SUMIFS was introduced in Excel 2007. A lot of people shifted to using SUMIFS instead …

Read more

How to Auto Format Formulas in Excel (3 Easy Ways)

Autoformat Formulas result after using conditional formatting

When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …

Read more

How to Extract URL from Hyperlinks in Excel (Using VBA Formula)

Using formula to extract URL from a cell in Excel

If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …

Read more

Post navigation
Newer posts
← Previous Page1 … Page5 Page6

Most Popular Articles

How to Compare Two Columns in Excel (using VLOOKUP & IF)

Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples

How to Remove Dashes (-) in Excel?

How to Center the Worksheet Horizontally on the Page in Excel

How to Merge First and Last Name in Excel

How to Remove Commas in Excel (from Numbers or Text String)

Why does Excel Open on Startup (and How to Stop it)

How to Remove Apostrophe in Excel

How to Unsort in Excel (Revert Back to Original Data)
SpreadsheetPlanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2022 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status