Apostrophy Detection
I need a function that returns TRUE if its argument (a string) has a leading
apostrophy, otherwise FALSE.
So if A1 contains a then APOS(A1) should return FALSE.
if A1 contains 'a then APOS(A1) should return TRUE.
The difficulty I am having is that the LEN function ignores the apostrophy
and the LEFT function does the same.
Thanks in advance
--
Gary's Student
|