software

My formula, thanks to everyone's wonderful help, has now evolved to:

=IF(LEFT(A1)=quot;#quot;,MID((UPPER(MID(A1,1,2))amp;LOWER(MID (A1,3,255))),2,255),IF(LEFT(A1)=quot;%quot;,UPPER(MID(A1,2 ,255))))

I'd like to add LOWER(A1) in there somehow, so if neither of these two
conditions are met, it doesn't display quot;false,quot; but it converts everything in
cell A1 to lowercase. I've tried lots of things and nothing seems to work,
please help me out one more time, I'd be forever grateful! Thanks!

=IF(LEFT(A1)=quot;#quot;,MID((UPPER(MID(A1,1,2))amp;LOWER(MID (A1,3,255))),2,255),
IF(LEFT(A1)=quot;%quot;,UPPER(MID(A1,2,255)),
IF(EXACT(A1,LOWER(A1)),LOWER(A1))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jezzica85quot; gt; wrote in message
...
gt; My formula, thanks to everyone's wonderful help, has now evolved to:
gt;
gt;
=IF(LEFT(A1)=quot;#quot;,MID((UPPER(MID(A1,1,2))amp;LOWER(MID (A1,3,255))),2,255),IF(LEF
T(A1)=quot;%quot;,UPPER(MID(A1,2,255))))
gt;
gt; I'd like to add LOWER(A1) in there somehow, so if neither of these two
gt; conditions are met, it doesn't display quot;false,quot; but it converts everything
in
gt; cell A1 to lowercase. I've tried lots of things and nothing seems to
work,
gt; please help me out one more time, I'd be forever grateful! Thanks!
Hi Jessica

Try
=IF(LEFT(A1)=quot;#quot;,
MID((UPPER(MID(A1,1,2))amp;LOWER(MID(A1,3,255))),2,25 5),
IF(LEFT(A1)=quot;%quot;,
UPPER(MID(A1,2,255),
LOWER(A1))))

--
Regards

Roger Govierquot;jezzica85quot; gt; wrote in message
...
gt; My formula, thanks to everyone's wonderful help, has now evolved to:
gt;
gt; =IF(LEFT(A1)=quot;#quot;,MID((UPPER(MID(A1,1,2))amp;LOWER(MID (A1,3,255))),2,255),IF(LEFT(A1)=quot;%quot;,UPPER(MID(A1,2 ,255))))
gt;
gt; I'd like to add LOWER(A1) in there somehow, so if neither of these two
gt; conditions are met, it doesn't display quot;false,quot; but it converts
gt; everything in
gt; cell A1 to lowercase. I've tried lots of things and nothing seems to
gt; work,
gt; please help me out one more time, I'd be forever grateful! Thanks!