Thread: Extract data from a cell reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fanny Fanny is offline
external usenet poster
  
Posts: 21
Default Extract data from a cell reference
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