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 LOWER function will convert all text (whatever the case) to lowercase text.
If cell A1 contains MiCHaeL, then:
=LOWER(A1)
returns michael
Guru Spotlight |
Jerry Mayo |