Skip to content
Spreadsheet Planet Logo
  • About
  • Excel Tips
  • Formulas
  • VBA / Macros
Menu
  • About
  • Excel Tips
  • Formulas
  • VBA / Macros
Search
Close

Formulas Articles

Combine Names using Flash Fill with capitalized first letter

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

Click here to Read More »
Add days to date using the DATE function

How to Add Days to a Date in Excel

Click here to Read More »
Numbers with comma

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

Click here to Read More »
Insert Square Root symbol using UNICHAR formula

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

Click here to Read More »
Standard Error Value from Data Analysis Toolpak

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

Click here to Read More »
Filter formula in cell E4

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

Click here to Read More »
Formula to subtract columns from a cell

How to Subtract Multiple Cells from One Cell in Excel

Click here to Read More »
Select every other cell in a column in Excel

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

Click here to Read More »
SUMIFS Vs SUMPRODUCT

SUMPRODUCT vs SUMIFS Function in Excel

Click here to Read More »
Autoformat Formulas result after using conditional formatting

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

Click here to Read More »
Using formula to extract URL from a cell in Excel

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

Click here to Read More »
« Previous Page1 Page2 Page3 Next »

2021 © Spreadsheet Planet
Privacy Policy | Sitemap

DMCA.com Protection Status