Thread: Lookup Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
klswvu[_2_] klswvu[_2_] is offline
external usenet poster
  
Posts: 27
Default Lookup Function
Microsoft has an excellent article on doing this woth and Array Formula

Extracting numbers from alphanumeric strings
http://office.microsoft.com/en-us/ex...549011033.aspx

Reply With QuoteReply With Quote