View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel Prg Excel Prg is offline
external usenet poster
 
Posts: 1
Default Excel Prg to retreive numeric values

Suppose Cell A1 has "TWID10293 Comments" entry an
cell A2 has "TW298382 Comment on this." entry
I wish to retrieve the numeric part of A1 and A2 in B1 and B2 respectively. ie B1 should have "10293" and B2 should have "29382".