Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.
Excel's MID function returns a number of characters that you specify from a text string, starting from a position which you specify.
If cell A1 contains Michael Gurner, then:
=MID(A1,4,7)
returns hael Gu (seven characters, staring from character number 4).
Guru Spotlight |
Byron White |