Manuals/calci/MIDB
MIDB(Text, Start_num, Number_chars)
where,
Text - is the text string to extract.
Start_num - is the position of the first characters.
Number_chars - represents the number of charcaters you want MID to extract.
MIDB returns a spcific number of characters from a text string, based on the number of bytes you specify. MIDB is intended for use with languages that use the double-byte character set (DBCS).
If Start_char < 1, MIDB returns #ERROR.
If Number_chars < 0, it returns #ERROR.
If Start_char > Lengthof Text, It returns all text.
If Start_char or Number_chars omitted, it returns all text
MIDB
Lets see an example in (Column1, Row2)
=MIDB(R1C1,2,6)
MIDB returns OHN S.
Lets see an another example in (Column1,Row4)
=MIDB(R1C1)
MIDB returns JOHN SMITH.
Consider an example in (Column1, Row3)
=MIDB(R1C1,2)
MIDB returns JOHN SMITH.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | JOHN SMITH | |||
| Row2 | OHN S | |||
| Row3 | JOHN SMITH | |||
| Row4 | JOHN SMITH | |||
| Row5 | ||||
| Row6 |
| TABLE3 | File:Calci1.gif | $ |
