Clean up text
Replace or remove characters in text
=SUBSTITUTE(A2,"-","")How it works in Excel
- A2 is the text.
- "-" is what to find.
- "" is what to put in its place, which here is nothing.
- It matches upper and lower case exactly.
- For a one-time cleanup, Ctrl+H does the same job.
The idea in general
It is find and replace, but as a formula that keeps working.
What I assumed
- The text is in A2 and you want to remove dashes.
Check the result on your own data before relying on it.