ExcelHow

Author: scott

Google Sheets DEGREES Function

Google Sheets Math Functions

April 25, 2023
How to Sort Data without Column Header Row in Excel

Excel Examples

April 25, 2023
How to Replace # Errors with Zero or Any Specific Value in Excel

Excel Examples

April 25, 2023
How to Merge Two List without Duplicates in Excel

Excel Examples, Excel VBA

April 24, 2023
Google Sheets MIDB Function

Google Sheets Text Functions

April 24, 2023
How to Create Increment Number with Texts in Excel

Excel Examples

April 24, 2023
How to Extract Year from Date & Time Format in Excel

Excel Examples

April 22, 2023
How to Apply Conditional Formatting across Workbook in Excel

Excel Examples

April 20, 2023
How to Auto Convert KB, MB, GB, PG, TB in Excel

Excel Examples

April 20, 2023
How to Extract Bold Text from A List in Excel

Excel Examples, Excel VBA

April 19, 2023
How to Print a Table without Color Filled in Cells in Excel

Excel Examples

April 19, 2023
How to Calculate Thanksgiving Date

Excel Examples, Excel VBA

April 18, 2023
How to Count Spaces before the Text String

Excel Examples, Excel VBA

April 18, 2023
How to Transpose Values Based on the Multiple Lookup Criteria

Excel Examples

April 17, 2023
How to Concatenate Text based on unique values in Another Column in Excel

Excel Examples, Excel VBA

April 17, 2023
How to Find and Replace Across Worksheets in Excel

Excel Examples, Excel VBA

April 17, 2023
How to Get Another Cell Value If One Cell Equals in Excel

Excel Examples

April 17, 2023
How to Remove the First/Last Word from Text string in Cell

Excel Examples, Excel VBA

April 16, 2023
How to Extract Email Address from Text

Excel Examples, Excel VBA

April 16, 2023
How to Hide or Show Objects in Excel

Excel Examples, Excel VBA

April 16, 2023