Clean up text
Find where a character is in text
=SEARCH("-",A2)How it works in Excel
- "-" is what to look for.
- A2 is the text.
- The result is its position, counting from 1.
- SEARCH ignores upper and lower case, and FIND does not.
- If it is not found, you get #VALUE!.
The idea in general
It tells you how many steps along the text you have to go.
What I assumed
- The text is in A2.
Check the result on your own data before relying on it.