Thread: Testing the case of text in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
  
Posts: 829
Default Testing the case of text in a cell
"Howard Silcock" wrote:
Can anyone suggest a simple way, using formulas,
to test whether the text in a cell is all lowercase?

=IF(EXACT(A1,LOWER(A1)),"all lowercase","not all lowercase")

Reply With QuoteReply With Quote