Excel Help

  mikegoggs2000 21:07 04 Dec 03
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 03

PS I'm Using Office XP

  VoG II 21:09 04 Dec 03

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 03

=UPPER(A1)

I meant.

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

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5