Changing Upper Case to Lower in Excel

  steviegee 08:22 04 Sep 2007
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 2007

With text in A1

=PROPER(A1)

  steviegee 08:47 04 Sep 2007

Thanks

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

The secrets of creating gory VFX

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache