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

    Types Of Headings In HTML

    HTML Hedings Headings in HTML are used to display Titles, Sub-Titles of Sub-Sub-Titles for your web page text. There are six types of headings in HTML. H1 is the largest heading and H6 is the smallest heading. <H1> is opening tag whereas </H1> is the closing tag for the largest heading. The text between <h1> and </h1> will be displayed as the main Title in your web page. Following are the six tags used for six types of headings in HTML. <H1> ... </H1> <H2> ... </H2> <H3> ... </H3> <H4> ... </H4> <H5> ... </H5> <H6> ... </H6> The H1 heading is used for main titles. Actually H1 heading will show the text in largest font size. H2 headings is used for Sub-Titles. H2 displays text in smaller font size than H1, H3 displays text of font size smaller than H1 and H2, and so on. H1 is for largest heading in a text page and H6 is for smallest heading.   Importance Of Headings in SEO H...
    Post a Comment
    Read more

    Explain different types of storage devices

    Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices:  Magnetic Tape   Magnetic Disk   Optical Disk   Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...
    3 comments
    Read more

    Explain Advantages Of Networks

    Define Network with examples. Give importance of Computer Network. COMPUTER NETWORK We can define a Computer Network as a set of two or more connected computers to share information and other resources (data, files, printers, hard disk, modem, CD-Rom Drive, CD-Writer, DVD-Rom Drive, DVD-Writer etc.). The computers in a network can share: Data, Information, Files Software Hardware (printers, disk, modems)etc. Advantages of Computer Networks EXAMPLES OF COMPUTER NETWORK Computer network can be used in an office. Different people in the office can share common information and printer. Net Cafes use Computer Network for internet sharing. Net Cafe Owners can save money by sharing one DSL Routers / Modem and a single Internet Connection. Computer Network is used in Computer Laboratories of Schools, Colleges and other educational institutes. Internet, is also an example of a computer network. Internet is a network of millions of computers connected through phone lin...
    Post a Comment
    Read more