Excel’s FIND() function parses a substring by finding the position of a specific character or string. This function uses the form. FIND(find_text, text, [start_num]) ...

The above formula will return 9, since the substring 12345 starts at that position. The FIND function is case-sensitive. It distinguishes between uppercase and lowercase letters.

For example, type "=MID(A1, 25, 4)" to extract the substring that begins at position 25 and has four characters; ... Excel Formula to Find Differences in Numbers.

If you want to parse strings such as "First Last" into separate columns, you don't need to use fancy formulas. Excel has a tool that makes the job a snap. In “Save time by using Excel’s Left ...