MID Formula in Microsoft excel

  

MID

Check below example and try to use in excel in real time for better understanding

Blue text start with "=" is the formula we used

MID FORMULA

What Does It Do ?

This function picks out a piece of text from the middle of a text entry.
The function needs to know at what point it should start, and how many characters to pick.
If the number of characters to pick exceeds what is available, only the available characters will be picked.

Syntax

=MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick)

Formatting

No special formatting is needed.

Example1

The following table uses the =MID() function to extract a post code from a branch ID used by a company.
It is assumed that all branch ID's follow the same format with the letters identifying the postal region being in the 5th and 6th positions.


Example 2

This example shows how to extract an item which is of variable length, which is inside a piece of text which has no standard format, other than the required text is always between two slash / symbols.


Find the first /, plus 1 for the Start of the code.
Find the second /, occurring after the first /
Calculate the length of the text to extract, by subtracting the position
of the first / from the position of the second /

Comments

Post a Comment

Popular posts from this blog

FREE MICROSOFT EXCEL TUTORIAL / Learn free online Microsoft excel

Image
Introduction to Microsoft Excel What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to analyze data and record number and text. In Microsoft Excel we can use many features like calculations, pivot tables, graphs, automation by macros etc. in Excel columns and rows makes a table. Columns are align it right to left with A,B,C names, and  rows are align in Up to Down in numbers. where column and row meet together is called cell. The cell represent the column and the number together. Where you can get Microsoft Excel? There are number of ways in which you can get Microsoft Excel. You can buy it from a cybercafé or computer shop . Microsoft Excel is part of the Microsoft Office. or you can download it from the Microsoft website and have to purchase it before use. In this Microsoft Excel tutorial, we are going to cover the following topics about MS Excel. How to Open Microsoft Excel? Understanding the Ribbon Understanding the worksheet Customization Microsoft Excel Environ
Read more

Large Formula in Microsoft excel

Image
LARGE Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used LARGE FORMULA What Does It Do ? This function examines a list of values and picks the value at a user specified position in the list. Syntax =LARGE(ListOfNumbersToExamine,PositionToPickFrom) Formatting No special formatting is needed.   Example The following table was used to calculate the top 3 sales figures between Jan, Feb and Mar. Note Another way to find the Highest and Lowest values would have been to use the =MAX() and =MIN() functions.
Read more

Today Formula in Microsoft excel

Image
  TODAY Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used   What Does It Do ? Use this to show the current date. Syntax  =TODAY() Formatting The result will normally be displayed using the DD-MMM-YY format.   Example 1 The following example shows how the Today function is used to calculate the number of days since a particular day. Note that the result is actually the number of days before todays date. To calculate  a result which includes the current date an extra 1 will need to be added.   Example 2 The following example shows the number of days from today until the year 2000.
Read more