Text

MIDB function

Characters from the middle of text. MIDB works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=MIDB(text, start_num, num_bytes)

Argument	Use
`text`	required
`start_num`	required
`num_bytes`	required

On live data

In Sheets, MIDB sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

More text functions

CONCATJoin text strings LEFTFirst characters of text LENString length LOWERLowercase PROPERCapitalize each word SUBSTITUTEReplace text TEXTFormat a number or date as text TEXTJOINJoin texts with a delimiter TRIMRemove extra spaces ARRAYTOTEXTValues of an array as one text ASCFull-width characters to half-width BAHTTEXTNumber as Thai baht text

All 48 text functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations