seperate a cell

[dlb1228]

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

 

[Toppers]

If 2 is the first character:

=LEFT(A1,1)

=RIGHT(A1,3) will give U82

HTH

 

[Wood Grafing]

try using:

=Left(A1,1)

instead