Substring in excel

kennytm doesn’t provide an example so here’s how you do substrings:

=MID(text, start_num, char_num)

Let’s say cell A1 is Hello.

=MID(A1, 2, 3) 

Would return

ell

Because it says to start at character 2, e, and to return 3 characters.