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 FIND function searches for text you specify inside another text string and returns the position at which the text string starts.
One standard use for this function is to look for a the position of a space when separating text strings (generally in conjunction with either MID or LEFT).
|Sheri Ann Richerson|