Excel Help

  mikegoggs2000 21:07 04 Dec 2003
Locked

Hey

I know in word that you can swap between Uppercase and Lowercase and First Letter of each word Capitals by using Shift+F3 But I was wondering if you can do it in excel and if so how do you do it

Thank You

  mikegoggs2000 21:08 04 Dec 2003

PS I'm Using Office XP

  VoG II 21:09 04 Dec 2003

Not so easy in Excel. You need to enter a formula in another cell. Say your text is in A1

=UPPER(A)

converts to capitals.

=LOWER(A1)

converts to lower case

=PROPER(A1)

converts to first character capitalised, rest lower case.

  VoG II 21:11 04 Dec 2003

=UPPER(A1)

I meant.

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

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)