Thread: Extract data from a cell reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rich[_2_] Rich[_2_] is offline
external usenet poster
  
Posts: 47
Default Extract data from a cell reference
=mid(cell ref,3,4) ???


"Fanny" wrote:

Dear Helpers,

I have a cell reference as [PL0502.xls]Sheet1!$B$2. How can I extract the
information "0502" from it so that I can make a date from it?

thanks in advance.

Fanny
Reply With QuoteReply With Quote