=MIDB(A1,1,5) : Displays 5 character string in cell A1 starting from 1st position. Displays '''ABC D''' as the output. Space character is also included.
+
=MIDB(A1,1,5) : Displays 5 character string in cell A1 starting from 1st position. <br />Displays '''ABC D''' as the output. Space character is also included.
−
=MIDB(A3,1,1) : Displays 1 character string in cell A3 starting from 1st position. Displays '''*''' as the output.
+
=MIDB(A3,1,1) : Displays 1 character string in cell A3 starting from 1st position. <br />Displays '''*''' as the output.
<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
<font color ="Red">Need to give examples with characters/language supporting DBCS </font>