Latest Blog Posts - Page 343 of 412

How to Highlight Text in Excel (7 Easy Ways)

Jun 16, 2024

Here's an overview of where you can find the conditional highlight options in Excel. Method 1 - Highlight Text in Excel Using the Font ...

How to Highlight Text in Excel (7 Easy Ways)

How to Concatenate Apostrophe in Excel: 6 Easy Methods

Jul 3, 2024

Method 1 - Using Ampersand Operator (&) to Concatenate Apostrophe Steps: Type the following formula in cell D5. ...

How to Concatenate Apostrophe in Excel: 6 Easy Methods

How to Sum Values by Day in Excel (8 Easy Ways)

Aug 2, 2024

In this article, we’ll demonstrate 8 easy ways to sum values by day in Excel. Here is an overview: 8 Easy Ways to Sum Values by Day in ...

How to Sum Values by Day in Excel (8 Easy Ways)

How to Select Range Based on Cell Value VBA (7 Ways)

Jun 24, 2024

Method 1 - Selecting Range Based On Another Cell Value We will select the cell range in the Region and Sales column based on the string Apple in the ...

How to Select Range Based on Cell Value VBA (7 Ways)

How to Convert Column Number to Letter in Excel (3 Methods)

Jul 12, 2024

Method 1 - Convert Column Number to Letter in Excel Consider the following dataset which we will be using as our example to convert column number to ...

How to Convert Column Number to Letter in Excel (3 Methods)

How to Remove a Value in Excel (9 Methods)

Jul 6, 2024

The below dataset has 5 columns: Product Name, Order ID, Price, Order Date, and Status. Method 1 - Using a Keyboard Shortcut Steps: ...

How to Remove a Value in Excel (9 Methods)

How to Compare Text and Highlight Differences in Excel (8 Quick Ways)

May 14, 2024

To demonstrate our Methods, we'll use the following dataset containing the names of the best-selling books in an online shop over two consecutive ...

How to Compare Text and Highlight Differences in Excel (8 Quick Ways)

How to Select Columns with VBA (3 Easy Ways)

May 16, 2024

Download the Practice Workbook Selecting Columns with VBA.xlsm 3 Ways to Select Columns with VBA Consider the List of Company ...

How to Select Columns with VBA (3 Easy Ways)

How to Find a Character in Excel String (8 Easy Ways)

Apr 12, 2024

If we want to find specific characters of an Employee’s Name and ID, we have to find characters appearing in the Character Sign column. For a better ...

How to Find a Character in Excel String (8 Easy Ways)

How to Select Cell with VBA in Excel (6 Useful Ways)

Jul 5, 2024

Download the Practice Workbook Select Cell with VBA.xlsm How to Select a Cell with VBA in Excel Method 1 - Select a Cell of the ...

How to Select Cell with VBA in Excel (6 Useful Ways)

How to Remove Decimals in Excel (13 Methods)

Jun 17, 2024

In the sample dataset, there are a variety of different currencies, quantities and their exchange rate to USD. The decimals need ...

How to Remove Decimals in Excel (13 Methods)

VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

Jun 27, 2024

Method 1 - VBA Macro to Delete Columns Based on Cell Value in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...

VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

Check If Cell Contains Partial Text in Excel (5 Ways)

Apr 19, 2024

We will be using a sample product price list as a dataset to demonstrate all the methods. Method 1 - Check If Cell Contains Partial Text ...

Check If Cell Contains Partial Text in Excel (5 Ways)

How to Remove Semicolon in Excel?

May 25, 2024

Method 1 - Removing Ending Semicolon from Cells In the dataset below (B4:B9) containing some Microsoft Product names, there is a semicolon at the ...

How to Use Dynamic Range in Excel VBA (11 Ways)

Jul 6, 2024

We have a dataset of a company to demonstrate the ways of using a dynamic range in VBA. Method 1 - Select Cells Containing Values Through ...