Clean up text
Take characters from the middle
=MID(A2,5,3)How it works in Excel
- A2 is the text.
- 5 is the position to start from.
- 3 is how many characters to take.
- Combine it with SEARCH when the start position changes from row to row.
The idea in general
You choose a starting spot and how much to cut out.
What I assumed
- The text is in A2.
Check the result on your own data before relying on it.