Cell 'Import Sheet'!X2 contains text in both uppercase, propercasing,
and lowercasing....such as YES, NO, Yes, No, yes, no, Unknown
I am trying to write a formula that will convert everything to
uppercase...trim to just the 1st character...then determine if Y then
result is Y...if N then result is N...if anything else it is blank
here is what I wrote and I get a formula error:
=IF((PROPER(LEFT('Import Sheet'!X2,1)))="Y","Y",(PROPER(LEFT('Import
Sheet'!X2,1)))="N","N","")
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread:
http://www.excelforum.com/showthread...hreadid=502546