Name
MID
Synopsis
Use MID to return the desired number of characters starting at the specified location in the string.
To Calculate
=MID(Text
,Start_Num
,Num_Chars
)
All arguments are required for this function.
Example
Figure 18-5 illustrates how MID is used to get five characters from the center of a string by starting at character 11.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.