View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Antonio
 
Posts: n/a
Default First number in a string

The following sample string contains the number of items = 2463.

Is there an easy way to extract that number from similar strings?

The rest of the information is not needed.

I am thinking of using the value function to text between spaces but perhaps
there is something simpler or with code.

Thanks,

Antonio
WELLP INC STK 2.463 68,24115 137.915,80 1,50 71,06000 P 139.225,82 1,54
1.310,02 0,95