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.
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.