Clean up text
Take the last few characters
=RIGHT(A2,3)How it works in Excel
- A2 is the text.
- 3 is how many characters to take from the right.
- Spaces count as characters.
- The result is text, even if it looks like a number.
The idea in general
It keeps the end of the text and drops the rest.
What I assumed
- The text is in A2.
Check the result on your own data before relying on it.