On Thursday, April 3, 2014 10:05:24 AM UTC+11, joeu2004 wrote:
"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")

Thank you very much. I thought there must be a built-in function I could use.

Howard