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

Nokia 8 vs Galaxy S8

Best new design books 2017: From vintage infographics to the the psychology of type

iMac 21.5-inch (2017) review

Nokia 8 : design, caractéristiques techniques, date de sortie