Excel Functions Archives - Page 30 of 40

How to Use RIGHT Function in Excel: 6 Suitable Examples

May 20, 2024

Method 1 - Using RIGHT Function to Get a Substring Until Space Step 1: Write down the below formula in cell C5. ...

How to Use RIGHT Function in Excel: 6 Suitable Examples

How to Use MID Function in Excel (5 Ideal Examples)

Jun 29, 2024

The MID function extracts a specified number of characters from a cell with a customizable starting point. In this article, we will demonstrate 5 ...

How to Use MID Function in Excel (5 Ideal Examples)

How to Use LEFT Function in Excel: 4 Suitable Methods

May 31, 2024

Method 1 - Basic Use of LEFT Function: Extract String from Left Side Steps: Select Cell D5 and insert the following formula. =LEFT(B5,4) ...

How to Use LEFT Function in Excel: 4 Suitable Methods

How to Use REPT Function in Excel: 8 Suitable Examples

Jul 5, 2024

Method 1 - Basic Use of REPT Function in Excel In Column B, there are some characters or texts and in Column C, the number of times those characters ...

How to Use REPT Function in Excel: 8 Suitable Examples

How to Use Excel’s MAX Function (6 Examples)

Jul 15, 2024

Overview of the MAX Function Introduction to MAX Function in Excel The MAX Function is categorized under Excel STATISTICAL functions. This ...

How to Use Excel’s MAX Function (6 Examples)

How to Use Excel LOWER Function (5 Suitable Examples)

Nov 11, 2025

MS Excel provides us with various functions to help us customize the case of the text. Among them, the LOWER function is used to change the case of ...

How to Use Excel LOWER Function (5 Suitable Examples)

How to Use REPLACE Function in Excel (3 Suitable Examples)

Nov 11, 2025

In Microsoft Excel, the REPLACE function is generally used to replace or substitute a text. The replacement is based on its starting position and ...

How to Use REPLACE Function in Excel (3 Suitable Examples)

How to Use Excel COUNTBLANK Function (5 Ideal Examples)

Nov 11, 2025

Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical ...

How to Use Excel COUNTBLANK Function (5 Ideal Examples)

How to Use the FIND Function in Excel (7 Methods)

May 16, 2024

Method 1 – Extracting the Position of a Specified Character in a Text In the following dataset, Column B contains text values, and Column C ...

How to Use the FIND Function in Excel (7 Methods)

How to Use LEN Function in Excel – 7 Examples

Aug 10, 2024

This an overview of the LEN function. Syntax The LEN function is described with the following syntax: =LEN (text) ...

How to Use LEN Function in Excel – 7 Examples

How to Use CONCATENATE Function in Excel (4 Easy Methods)

Jul 2, 2024

Method 1 - Using CONCATENATE Function with Texts The sample dataset has Employee IDs, First Names, and Last Names in different columns. We will ...

How to Use CONCATENATE Function in Excel (4 Easy Methods)

How to Use the AVERAGE Function in Excel (5 Examples)

Jul 10, 2024

Introduction to Excel AVERAGE Function The AVERAGE function is categorized under the Statistical functions in Excel. This function returns the ...

How to Use the AVERAGE Function in Excel (5 Examples)

How to Use SMALL Function in Excel (4 Common Examples)

Aug 1, 2024

Here's an overview of the small function being used in a sample dataset. Introduction to the SMALL Function Function Objective: ...

How to Use SMALL Function in Excel (4 Common Examples)

How to Use the RAND Function in Excel – 5 Examples

Aug 14, 2024

This is an overview. The RAND Function in Excel This function returns a random number between 0 and 1. Syntax =RAND() ...

How to Use the RAND Function in Excel – 5 Examples

How to Use MIN Function in Excel (6 Relevant Examples)

Jul 15, 2024

In Microsoft Excel, the MIN function is used to extract the lowest or smallest value from a range of cells containing numerical data only. Here's an ...