Thread: #VALUE about function Find
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hui hui is offline
external usenet poster
  
Posts: 9
Default #VALUE about function Find
I set A1="1978-9-22", B1="find("-",A1)" and return, but B1 shows #VALUE!,
why? How can I resolve it? thanks in advance.

A B C
1 1978-9-22 =find("-",A1)
2
3


hui


Reply With QuoteReply With Quote