=LEFT(SUBSTITUTE(SUBSTITUTE(A1,"€¦",""),".",""),1 )

NOTE: I have the ... and the . because the ... is treated as an ellipses
unless specifically removed from the AutoCorrect feature.

Hope this helps.
--
John C


"Jason" wrote:

Hi,

I have a column of data that looks like
.......0....
.......0....
.........2.2.
.........2.2.
..11.2.2.2.2.2.2.2.2.
2.2.2.2.2.2.2....
........2...2
........2...
2.2.2.2.2.2.2.2.2.2.

I would like to extract the left-most number from each cell. How can
I do this with a formula? The number will be either one or two
digits.

Thanks,
Jason