Excel Function

MID

Returns characters from middle of text.

MID(text, start_num, num_chars)

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

start_num

Required

Enter a numeric value.

num_chars

Required

Enter a numeric value.

Practice Preview

format and display text values. Use MID to Returns characters from middle of text. use B2 for text, use 2 for start_num, use 4 for num_chars. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=MID(B2, 2, 4)

Practice This Function

Practice in Sequential Mode Back to Function List