i have a column and want to separte see example
2 U82
2 U83

i want to separate i thought i could do it like this

=left(A1,4) should give me 2
i thought please help