How to Remove a Space after a Number in Excel (6 Easy Ways)

The below dataset contains the names of 4 products and their codes. The product codes contain extra spaces after numbers. Method 1 – Using ...

How to Move Merged Cells in Excel – 3 Methods

This is the sample dataset. Method 1 - Using the Paste Special Command to Move Merged Cells Steps Move B5:E9 to the empty range ...

How to Automatically Link a Cell Color to Another in Excel

To demonstrate how to link a cell color to another automatically, we'll use the following dataset containing some subjects in column B and ...

How to Split Names into Three Columns in Excel (3 Methods)

When you have a list of complete names and wish to separate them into first, middle, and last names, you may use Excel features to divide the cells. ...

How to Separate First Name Middle Name and Last Name in Excel Using Formula

This article will show how to separate the first name, middle name, and last name using Excel formula. To get a quick view of the formulas, consider ...

Growth Formula in Excel with Negative Numbers (3 Examples)

In Excel, it is a simple task to create an accurate growth formula when all the numbers have a positive value. But there is unfortunately no growth ...

How to Transpose Column to Multiple Rows in Excel: 6 Methods

Method 1 - Using Excel TRANSPOSE Function to Transpose Column to Multiple Rows Steps: Type the following formula in cell B12. ...

Excel VBA: Get Row and Column Number from Cell Address (4 Methods)

How to Write Code in the Visual Basic Editor To get row and column numbers from cell addresses, we need to open and write VBA code in the Visual ...

How to Fix Excel Cells Not Being Able to Move: 5 Solutions

Solution 1 – Disabling Scroll Lock in Excel Steps: Right-click on the Status bar at the bottom of the worksheet. Select Scroll Lock to turn ...

Excel VBA: Create New Line in MsgBox (6 Examples)

Example 1 - Use vbNewLine to Add New Line in MsgBox Using Excel VBA We will show “Hello!” in the first line and “Welcome to ExcelDemy” in the second ...

How to Separate Numbers from Text in Excel VBA – 3 Methods

Quick View Public Function SeparateText(Rng As Range, Number As Boolean) As String Dim a As Long Dim b As String a = VBA.Len(Rng.Value) For i = ...

How to Extract Multiple Numbers from a String in Excel – 6 Methods

The dataset showcases  ID (7 digits), Name, and ZIP Code (5 digits) in a single cell. To extract ID and ZIP Code:   Method 1 - ...

Move and Size with Cells in Excel (3 Examples)

In this article, we will describe how to move and size objects with cells in Excel using the Move and size with cells property. Checking this option ...

How to Move Highlighted Cells in Excel (5 Ways)

We'll use the data of 10 employees of a company. Their names and salaries are in columns B and C. We will highlight the entities that are in the ...

Move One Cell to Right Using VBA in Excel: 3 Methods

Method 1 - Move One Cell to Right Using Range Property Steps: Open the Developer tab. You can open it by pressing Alt+F11, or you can customize ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo