writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 47:
Line 47: − + − + − + − + + + + +
no edit summary
|}
|}
=MID(A1,1,3) : Displays 3 character string in cell A1 starting from 5th position. Displays '''Wel''' as the output.
=MID(A1,1,3) : Displays 3 character string in cell A1 starting from 5th position. <br />Displays '''Wel''' as the output.
=MID(A2,7,14) : Displays 14 characters in cell A2 starting from 7th position. Displays '''Orange''' as the output.
=MID(A2,7,14) : Displays 14 characters in cell A2 starting from 7th position. <br />Displays '''Orange''' as the output.
=MID(A3,1,1) : Displays character string in cell A3 starting from 1st position. Displays '''*''' as the output.
=MID(A3,1,1) : Displays character string in cell A3 starting from 1st position. <br />Displays '''*''' as the output.
=MID("good" & "morning",1,8) : Joins the two strings and returns 8 characters starting from 1st position. Displays '''goodmorn''' as the output.
=MID("good" & "morning",1,8) : Joins the two strings and returns 8 characters starting from 1st position. <br />Displays '''goodmorn''' as the output.
==Related Videos==
{{#ev:youtube|6uxeKVfA8JQ|280|center|MID}}
== See Also ==
== See Also ==