Excel Snippets: FIND and SEARCH Functions

I might not post many Excel snippets, but I’m collecting them into a small series to make them easy to find. FIND and SEARCH both locate the position of one text string within another, returning the character number at which it starts. The key difference between them is that FIND is case-sensitive while SEARCH is...

Read original post Excel Snippets: FIND and SEARCH Functions at azurecurve|Ramblings of an IT Professional