Thread: Picking values out
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Picking values out
Hi Jez,

Try this one:

=MID(A2,FIND("*",A2,1)+1,FIND("*",A2,FIND("*",A2,1 )+1)-FIND("*",A2,1)-1)

Regards,
Bondie

Reply With QuoteReply With Quote