View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason[_11_] Jason[_11_] is offline
external usenet poster
 
Posts: 17
Default How to extract left-most number from a string

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