Thread: How to recognise a small letter as being different to a capital le
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to recognise a small letter as being different to a capital le
Use =EXACT()
--
Gary's Student


"Suza" wrote:

Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function
Reply With QuoteReply With Quote