Thread: Search
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Search

Assuming your values are in A1 to A4, type this formula into B1 and
copy down:

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Sum these values to get 275.

Hope this helps,

Pete