“MID”
Used for – “MID” function in MS Excel is
used to pick the specified number of characters starting from a desired
position in a text string or in a cell and display the same as a result.
Syntax – MID(text, start_num,
num_chars).
Example – Following example will clear
the date function:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
EXCEL
WITH EASE
|
||||||||
2
|
=MID(A1,1,5)
|
=MID(A1,7,4)
|
=MID(A1,12,4)
|
||||||
3
|
=MID(A1,3,5)
|
=MID(A1,5,4)
|
=MID(A1,9,4)
|
||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
|||||||||
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
EXCEL
WITH EASE
|
||||||||
2
|
EXCEL
|
WITH
|
EASE
|
||||||
3
|
CEL
W
|
L
WI
|
TH
E
|
||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
|||||||||
Note:-
The MID Function counts each character in the text string and if there are any
extra spaces are typed in the string it will count them too. So you should be
more careful using this function
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.