Function: LEFT in Excel

Function: LEFT in Excel

by | Nov 26, 2018

The LEFT function in Excel is a powerful tool for extracting substrings from a given string, starting from the leftmost character. This function is particularly useful when you need to isolate specific portions of text from a larger string. To use the Excel LEFT...
How to delete all comments in Excel using VBA

How to delete all comments in Excel using VBA

by | Nov 26, 2018

Excel, just like other Office products, supports comments. Although comments are helpful to add tips or other details into your spreadsheets, deleting them may become time consuming while trying to find and select all of them. In this article, we’re going to...
How to delete Excel shapes (AutoShapes) using VBA

How to delete Excel shapes (AutoShapes) using VBA

by | Nov 20, 2018

Excel, just like other Office products, supports AutoShapes. Although Excel shapes are nice to have for presentation purposes, getting rid of them may become time consuming if your workbook is cluttered with them. This article shows you how to delete Excel shapes...
Function: DATE

Function: DATE

by | Nov 19, 2018

The DATE function in Excel returns a date serial number from specified year, month and day values. In this guide, we’re going to show you how to use the DATE function and also throw in some tips and error handling methods.Supported versionsAll Excel versionsDate...
How to make Excel delete all pictures

How to make Excel delete all pictures

by | Nov 16, 2018

Excel, just like other Office products, supports inserting pictures of various formats into your workbooks. However, deleting them may be time consuming in large workbooks if you’re trying to find and delete every single image manually. Let us show you how to...
How to remove hyperlink in Excel quickly using VBA

How to remove hyperlink in Excel quickly using VBA

by | Nov 15, 2018

Excel, just like other Office products, can detect URLs and email addresses, and turn them automatically into hyperlinks. While this can usually speed things up when creating workbooks, they can become nuisance when you don’t want them to be clickable links with...
Function: DAY

Function: DAY

by | Nov 13, 2018

This function allows users to isolate and work with specific day values, which can be particularly useful for various date-related calculations and analyses. In this comprehensive guide, we'll walk you through the ins and outs of the DAY function in Excel, providing...
How to make Excel update links using VBA

How to make Excel update links using VBA

by | Nov 13, 2018

Excel doesn’t automatically update any external links in your workbooks and this can become a hassle if it’s something happening frequently. In this article, we’re going to show you how to make Excel update links automatically using VBA. How to make...
Function: LOWER

Function: LOWER

by | Nov 12, 2018

The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax LOWER(text) Arguments text The text you want...