How to Check If a String Contains Another String in Excel Using VBA (6 Methods)

Method 1 - Checking for Substrings Open the Visual Basic Editor by pressing Alt + F11 or navigating to the Developer tab and clicking on Visual ...

How to Remove Formulas in Excel – 8 Easy Methods

A sample dataset is shown below. Download Practice Workbook Download and practise. Removing Formulas.xlsm How to Remove ...

How to Remove the Dollar Sign in Excel – 7 Methods

The pre-formatted dataset shows the dollar sign ($) before the Price value. Method 1- Using the Format Cells Feature to Remove the Dollar ...

How to Edit Macros in Excel (2 Ideal Methods)

Here's an overview of using the Macros option to edit macros in a sheet. How to Unhide a Macro in a Personal Workbook Your macros can be ...

How to Find a Circular Reference in Excel (2 Easy Tricks)

Sometimes we input an Excel formula in a worksheet but it’s not working for some reason. It shows a warning prompt instead which mentions Circular ...

How to Insert a Total Row in Excel (4 Easy Methods)

We have a sample dataset below of different items, their prices, quantities purchased, and total prices. We will insert a total row in this dataset ...

How to Find an Exact Match Using VBA in Excel (5 Easy Ways)

Suppose you have the following dataset: Method 1 - Find an Exact Match in a Range of Cells Steps: Press Alt+F11 on your keyboard to ...

How to Remove Space Before Text in Excel (4 Methods)

  How Space Before Text Affects the Dataset? Space(s) before the text can create a lot of trouble to analyze a dataset. It may give you wrong ...

How to Trim Text in Excel

Sometimes we need to trim space or character from an entire text in Excel to make the dataset attractive. We can use different Excel functions like ...

How to Find a text within a Range Using VBA in Excel – 4 Methods

The sample dataset contains Book Names, Authors, and Prices. 1. Finding an Exact Match Within a Range with VBA in Excel (Case-Insensitive ...

How to Convert Serial Number to Date in Excel (7 Simple Ways)

Method 1 - Converting Serial Number to Date in Excel with Format Cells Option Steps: Select the C5:C16 cells >> Right-click to open the ...

Split String by Character in Excel (6 Suitable Ways)

The sample dataset below contains the Contact Information of random people where Name, Email Address and Contact Number are entered as a single ...

How to Wrap Text Using Shortcut Keys (2 Hotkeys)

What is Text Wrapping? Text wrapping refers to converting single-line text into multiple lines to better display cell contents to users. ...

How to Rename Sheet in Excel (6 Suitable Ways)

While working in Excel, often we have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. In ...

How to Use the SUMIF Function between Two Values in Excel

The dataset used for these methods contains three columns with the product ID, prices of the products, and delivery dates of a company's products.  ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo