G Guest Oct 2, 2007 #1 If A1 is uppercase B1must be lower if not it must remain uppercase please help for this formula thank you
If A1 is uppercase B1must be lower if not it must remain uppercase please help for this formula thank you
G Guest Oct 4, 2007 #2 In B1: =IF(UPPER(A1)=A1,LOWER(A1),A1) should do it, if I understand your question correctly If A1 might be mixed case and you want B1 to be always all upper or all lower, maybe this is actually what you want: =IF(UPPER(A1)=A1, LOWER(A1), UPPER(A1))
In B1: =IF(UPPER(A1)=A1,LOWER(A1),A1) should do it, if I understand your question correctly If A1 might be mixed case and you want B1 to be always all upper or all lower, maybe this is actually what you want: =IF(UPPER(A1)=A1, LOWER(A1), UPPER(A1))
R raju Apr 8, 2010 #3 Dear Sir, in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather who it possible. raju mumbai
D Dave Peterson Apr 11, 2010 #4 =proper(a1) May work for you. Dear Sir, in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather who it possible. raju mumbai Click to expand...
=proper(a1) May work for you. Dear Sir, in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather who it possible. raju mumbai Click to expand...