Excel LEFT Function

What is the LEFT function in Excel?

The LEFT function is one of the (TEXT) functions of Excel. It returns the specified number of

characters from the start of a text string.

We can find this function in TEXT of insert function Tab.

How to use LEFT function in excel

  1. Click on empty cell (like F5 )

2. Click on fx on the below of font word (or press shift+F3)

3. In insert function tab you will see all functions

4. Select TEXT category

5. Select LEFT function

6. Then select ok

7. In function arguments Tab you will see LEFT function

8. Text is the text string containing the characters you want to extract

9. Num_chars specifies how many characters you want LEFT to extract; 1 if omitted

10. You will see the results in formula result section

Examples of REPLACE function in Excel

What is the purpose of REPLACE function?

It replaces part of a text string with a different text string.

What is the Return value  of REPLACE function?

It just returns the number.

SEARCH (Find text,Within text,Start num)=number

How many arguments does REPLACE function have?

SEARCH (Old text,Start num,Num_chars,New text)

REPLACE function has 4 argument.

Old text is text in which you want to replace some characters

Start num is the position of the character in Old text that you want to replace with New text

Num_chars is the number of characters in Old text that you want to replace

New text is the text that will replace characters in Old text

Which version of excel supports REPLACE function?

This function is available for all excel versions (2003-2019)

Errors in REPLACE function

Leave a Reply

Your email address will not be published. Required fields are marked *