Skip to main content

Uses of Left Right Mid Text Functions in Excel

Why To Use Left Function in Microsoft Excel?

The Left function is used to get first N characters from the given text string or the text contained in a cell.

Syntax of LEFT Function in Excel


LEFT(Text, Number_of_characters)

For example, the function LEFT("Normal",3) will return Nor.

Syntax of LEFT function with Cell Reference


LEFT(CellReference, Number_of_characters)

For example, let the cell A2 contains the text Humanity, the function LEFT(A2,5) will return Human.
Similarly if Cll A12 contains "England" then Left(A12,5) will give "Engla" that is first five characters of contents of cell A12 from left side.

How To Implement LEFT Function in Excel

Uses of Excel Functions Left Right in Excel Worksheet
Uses of Excel Functions Left Right in Excel Worksheet

 

 First of all place the cursor in an empty cell next to cell A2, to enter the function.
  • Type =
  • Type the function name LEFT
  • Type the left parenthesis (
  • Type A2 from keyboard.
  • Type , (that is Comma)
  • Type 5 so that the first 5 characters will be returned from cell A2's text. 
  • Press Enter key (You need not to enter right parenthesis, it will be automatically included)
  • The result Human will be displayed in the cell.
 Note: Number_of_characters will be normally greater than zero. If Number_of_characters will greater than the total length of the text then All the text will be returned. For example, in above example the function LEFT(A2, 10) will return the whole text in cell A2 that is Humanity.
Similarly, if we ignore the value of Number_of_characters then it is assumed to be 1 by default. So that the function LEFT(A2) will return only one character that is H.

Why To Use Right Function in Microsoft Excel?

The Right function is used to get the last N characters in a text string. Where N is the number of characters to be extracted from the given string.

Syntax of RIGHT Function in Excel


RIGHT(Text, Number_of_characters)

For example, the function Right("Night",2) will return ht.

Syntax of RIGHT function with Cell Reference


RIGHT(CellReference, Num_of_char)

For example, let the cell A2 contains the text Saturday, the function RIGHT(A2,3) will return day.

How To Implement RIGHT Function in Excel

uses-of-RIGHT-Excel-Function-Example-data-Results
 First of all place the cursor in an empty cell next to cell A2, to enter the function.
  • Type =
  • Type the function name RIGHT
  • Type the left parenthesis (
  • Type A2 from keyboard.
  • Type , (that is Comma)
  • Type 3 so that the last 3 characters will be returned from cell A2's text. 
  • Press Enter key (You need not to enter right parenthesis, it will be automatically included)
  • The result day will be displayed in the cell.
Note:
  • Num_of_char will be greater than zero normally. 
  • If Num_of_char is greater than the length of given text, then RIGHT function will return all of text. 
  • If the value of Num_of_char is not used then its default value 1 is used and only one last character is returned by the RIGHT function.

Why To Use MID Function in Microsoft Excel?

The MID function is used to get the last N characters in a text string. Where N is the number of characters to be extracted from the given string.

Syntax of RIGHT Function in Excel


MID(text, start_num, num_chars)

For example, the function MID("Night",1,3) will return Nig.

Syntax of RIGHT function with Cell Reference


RIGHT(CellReference, start_num, num_chars)

Where start_num is the number of starting character and num_chars is total number of characters to be extracted from the text.
For example, let the cell A2 contains the text Reservation,
  • the function MID(A2,6,3) will return vat.
  • the function MID(A2,6,10) will return vation. Since 10 is greater than the length of 6 th character to end of text, so this MID function will return all text starting from 6th character v to last character n.
  • the function MID(A2,1,1) will return only one character starting from position 1 that is R.

How To Implement RIGHT Function in Excel

uses-of-MID-Excel-TEXT-Function-Example

 First of all place the cursor in an empty cell next to cell A2, to enter the function.
  • Type =
  • Type the function name MID
  • Type the left parenthesis (
  • Type A2 from keyboard.
  • Type , (that is Comma)
  • Type 6 
  • Type ,
  • Type 3 so that the 3 characters from position 6 will be returned cell A2's text. 
  • Press Enter key (You need not to enter right parenthesis, it will be automatically included)
  • The result vat will be displayed in the cell.


    Labels:

    Comments

    Post a Comment

    Popular posts from this blog

    Explain Different Types Of Data

    DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form     contains raw facts (data of student) like name, father’s name, address of student etc. 2)    Data of Citizens During census, data of all citizens is collected. 3)    Survey Data Different companies collect data by survey to know the opinion of people about their product. 4)    Students Examination data In examination data about obtained marks of different subjects for all students is collected.    Different Types Of Data There are following main types of Data. 1)    NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...
    Post a Comment
    Read more

    Bus Topology Advantages Disadvantages

    Bus Topology Bus topology is the simplest network topology . In bus topology , all computers in network are connected to a common communication wire. This wire is called BUS. Terminators are used at both ends of wire. Bus Topology is Cheap, easy to handle and implement. Bus Topology require less cable. Bus Topology is best suited for small networks. Working of Bus Topology with Advantages and Disadvantages Advantages of Bus Network Topology 1. It is very simple topology . 2. It is easy to use. 3. It needs small amount of wire for connecting computers. 4. It is less expensive due to small wire needed. 5. If one computer fails, it does not disturb the other computers in network. Other computers will continue to share information and other resources with other connected computers. Disadvantages of Bus Network Topology 1. Only small number of computers can be connected in a bus network . 2. Network speed slows down as the number of computer increases in b...
    Post a Comment
    Read more

    Important Objective Type Questions 101-155

    MMC stands for multimedia card. SD stands for secure digital card. System Bus  is used to connect main components of a computer such as cpu and main memory. A Port is an interface or a point of attachments. POS stands for Point Of Sale terminal. ATM stands for Automated Teller Machine. PIN stands for Personal identification number. Kbps stands for kilobits per second. Mbps stands for megabits per second. A port that transmits one bit at a time is called Serial Port. A type of port that transmits many bits at a time is called Parallel Port. LPT stands for Line Printer. Examples of system software are Operating System, Utility Programs and Device Drivers. Examples of operating systems are DOS, Windows, Unix and Linux. Examples of Utility programs are File Manager, Image Viewer, Disk Scanner and File Compressor. Software used to detect and remove viruses is called Antivirus . Examples of antivirus programs are Mcaffee, Avast, ...
    3 comments
    Read more