EXACT comes to mind ..

Assuming in A2 down are the textstrings: tsp, Tbls
you could have something like this in B2, copied down:
=IF(EXACT(LEFT(A2),"t"),"Lower case t",IF(EXACT(LEFT(A2),"T"),"Upper case
T",""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"CRS" wrote:
in an IF formula, can I force recognition of case in a formula. I am trying
to set up a converversion table that needs to differentiate between upper-
and lower case case "t" (teaspoons vs. Tablespoons), so I don't have to
lengthen to tsp vs. Tbls.?