1. LEFT Function in Excel

The LEFT function is used to extract a specific number of characters from the left-hand side (beginning) of a text string.

Syntax:

• text → The text string from which you want to extract characters.

• num_chars → The number of characters you want to extract from the left.

Example 1:

If cell A1 = "ANILCOMPUTERS"

• Formula: =LEFT(A1, 4)

• Result: ANIL

 This extracts the first 4 characters from the left.

Example 2:

If cell B1 = "Udaipur123"

• Formula: =LEFT(B1, 7)

• Result: Udaipur

The first 7 characters are displayed.

2. RIGHT Function in Excel

The RIGHT function is used to extract a specific number of characters from the right-hand side (end) of a text string.

Syntax:

• text → The text string from which you want to extract characters.

• num_chars → The number of characters you want to extract from the right.

Example 1:

If cell A1 = "ANILCOMPUTERS"

• Formula: =RIGHT(A1, 8)

• Result: COMPUTERS

? This extracts the last 8 characters from the right.

Example 2:

If cell B1 = "Excel2025"

• Formula: =RIGHT(B1, 4)

• Result: 2025

? It shows the last 4 characters.

MID():

This function extracts characters from the middle of a string.

Example:

Result: ell

CONCAT():

This function joins the text from multiple cells into one.

Example:

Formula: =CONCAT(A1, " ", B1)
Result: Hello World

TEXTJOIN():

This function joins multiple ranges and strings using a delimiter.

• The first argument is the delimiter (e.g., comma, space).

• The second argument is whether to ignore empty cells (TRUE/FALSE).

• The third argument is the text range to join.

Example:

Formula: =TEXTJOIN(",", TRUE, A1:A5)
Result: AM, IT, BHA, RAT, PUR

Excel Advanced Formulas Tutorial in hindi blog

Thanks To Google

Thanks To ChatGPT