deepcalc
DocsMID

MID

View as markdown/docs/functions/mid.md Ask Claude about this pageOpens Claude with this page's address

Returns characters from middle of text.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Text

Examples

=MID("spreadsheet", 7, 5)
Result sheet

Syntax

MID(text, start_num, num_chars)
text
text required
start_num
number required
num_chars
number required
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.