If 2 is the first character:

=LEFT(A1,1)

=RIGHT(A1,3) will give U82

HTH

"dlb1228" wrote:

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