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

Formulas Articles

SUMIF formula to add only positive numbers

How to Sum Positive Numbers in Excel – Easy Formula

Click here to Read More »
COUNTIF Function to count negative numbers in a range

How to Count Negative Numbers in Excel – Easy Formula

Click here to Read More »
Date to convert to the day name

How to Convert Date to Day of Week in Excel (3 Easy Ways)

Click here to Read More »
TEXT function to change serial number to date

How to Convert Serial Numbers to Date in Excel

Click here to Read More »
Result after using the CLEAN function

How to Remove a Specific Character from a String in Excel

Click here to Read More »
TEXT formula

How to Convert Date to Month and Year in Excel (3 Easy Ways)

Click here to Read More »
Final result of flash fill

How to Add Text to the Beginning or End of all Cells in Excel

Click here to Read More »
Formula result with only the username

How to Remove Text after a Specific Character in Excel (3 Easy Methods)

Click here to Read More »
Copy and drag the formula for all cells

How to Count How Many Times a Word Appears in Excel (Easy Formulas)

Click here to Read More »
Concatenate all the alphabets

How to Reverse a Text String in Excel (Using Formula & VBA)

Click here to Read More »
Degrees Formula

How to Convert Radians to Degrees in Excel (Easy Formula)

Click here to Read More »
Unique random numbers without duplicates

How to Generate Random Numbers in Excel (Without Duplicates)

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

2021 © Spreadsheet Planet
Privacy Policy | Sitemap

DMCA.com Protection Status