=IF(UPPER (A1);LOWER; (A1))

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If A1 is uppercase B1must be lower if not it must remain uppercase please
help for this formula thank you
 
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))
 
Dear Sir,

in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather
who it possible.
raju
mumbai
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

upper case lower case 0
COMBO BOX vs Uppercase 6
filtering to separate upper & lower case 5
Convert to uppercase 1
Print Area to include text box 10
Excel Need Countifs Formula Help 0
Excel Excel Conditional Format 2
Upper / Lower Case 1

Back
Top