View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary's Student Gary's Student is offline
external usenet poster
 
Posts: 86
Default 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