G
Guest
If A1 is uppercase B1must be lower if not it must remain uppercase please
help for this formula thank you
help for this formula thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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))
=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
Dear Sir,
in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather
who it possible.
raju
mumbai
in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather
who it possible.
raju
mumbai
D
Dave Peterson
=proper(a1)
May work for you.
May work for you.
Dear Sir,
in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather
who it possible.
raju
mumbai