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.

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

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…