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

How secure is your Wi-Fi?

AMD vs Intel: we put the most powerful desktops for designers and artists head-to-head

iPhone tips & tricks

Les meilleurs ordinateurs portables 2017