Changing Upper Case to Lower in Excel

  steviegee 08:22 04 Sep 07
Locked

I have some text in excel (2003) that is in capitals how do I change it in bulk i.e YES to Yes and NO to No.

  VoG II 08:31 04 Sep 07

With text in A1

=PROPER(A1)

  steviegee 08:47 04 Sep 07

Thanks

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant