The MID function of Excel is used in Analysis of Data.. MID Function is very useful to split data into multiple columns. The MID function is used to pick up particular characters within the cell value.
For example, to split the Product Number from Barcode from
2nd Character to 9 characters.
The barcode number is 9100589451(in cell B3) and we need to get the
product code as 100589451. It can be achieved by formula:
MID Function in Excel
Type at C3 =MID (B3, 2, 9) that means,
- B3 --- Is the cell address of the source data (9100589451)
- 2 --- is the position of character From (data required)
- 9 --- is the number of characters from 2nd character required.
This will give result of: 100589461
READ:How to use Data validation Function in Excel | 7 Steps With Picture
OUTPUT
We will update soon for How to get the 10 characters at 5th
row using run time number of characters shortly... Please check back…
0 comments