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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…