Skip to Content

MIDB

Returns a specific number of characters from a text string starting at the position you specify, based on the number of bytes

Syntax

MIDB(text, start_num, num_bytes)

Parameters

  • text: Required. The text string containing the bytes you want to extract
  • start_num: Required. The position of the first byte you want to extract
  • num_bytes: Required. The number of bytes you want to return

Example

=MIDB("Fluid", 1, 5)
Returns: StringSince: Excel 2003