Steve Scott Articles

How to Apply Short Date Format in Excel?

Click here to Read More »

How to Move Row to Another Sheet Based On Cell Value in Excel?

Click here to Read More »

How to Extract Text After Space Character in Excel?

Click here to Read More »

How to Unmerge All Cells in Excel?

Click here to Read More »

How to Convert Month Name to Number in Excel?

Click here to Read More »

How to Remove Duplicate Rows based on one Column in Excel?

Click here to Read More »

Round UP or DOWN to Nearest 5 in Excel (Formula)

Click here to Read More »

How to Change All Caps to Lowercase Except the First Letter in Excel?

Click here to Read More »

How to Calculate Hours between two Times in Excel?

Click here to Read More »

How to Convert Decimal to Binary in Excel

Click here to Read More »

How to Separate Address in Excel?

Click here to Read More »

What is the Excel Personal Workbook Location?

Click here to Read More »