Change Case in Excel 2007

  flobby 20:14 10 Sep 07
Locked

Hi,
I have been sent a list of films (2224 to be exact) and they are all in differant fonts and sizes and cases.
I can and have changed the font and size by selecting column A and choosing font and size.
But How do I get to change all the list to Proper Case or Upper in one go? I Looked in the help section and it gave me the formula =proper But I am unsure how to put the formula to the whole list.
Thanks In Advance

  VoG II 20:16 10 Sep 07

If the list is in column A starting at row 1 then in B1 enter

=PROPER(A1)

and copy the formula down.

  VoG II 20:19 10 Sep 07

To copy the formula down, hover the cursor over the bottom right of A1 until the cursor turns into a + then double-click.

  flobby 20:28 10 Sep 07

Thank You,
I have now done it.
Cheers

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…