MID / LEN
In cell F 8 I have:-
4-12456
In cell I 8 I have:-
=MID(F8,3,LEN(F8))
The above formula returns 12456 in cell I 8. Why?
I know that MID, €śreturns a specific number of characters from a text
string, starting at the position you specify, and based on the number of
characters you specify€ť.
I know that LEN, €śreturns the number of characters in a text string€ť.
What I dont understand is how the MID feeds into the LEN and / or vice
versa.
TIA for any replies!
|