#VALUE about function Find
In Column A there are lots of unformated date data, some like 1978-9-22,
some like 1978-9, some like 1978.9.22, some like 78.9.22 or even 78.9
I wanna know what kind of date data in Column A by Function find and deal
with it.
hui
"Bob Phillips" ...
As I said, there are no "-" in there, it is just formatted to look that
way.
Why do you want to count them?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"hui" wrote in message
...
I wanna take A1 as a string and count how many "-" it has and find where
"-"
is. May I do it?
thanks
"Bob Phillips"
...
That is because the cell holds a number, it is just formatted as you
show
it, the - is not real.
If you want the year, just use
=YEAR(A1)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"hui" wrote in message
...
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
|