Clean up text
Take the first few characters
=LEFT(A2,3)How it works in Excel
- A2 is the text.
- 3 is how many characters to take from the left.
- Spaces count as characters.
- The result is text, even if it looks like a number.
The idea in general
It keeps the start 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.