Change Case in Excel 2007

  flobby 20:14 10 Sep 2007

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 2007

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


and copy the formula down.

  VoG II 20:19 10 Sep 2007

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 2007

Thank You,
I have now done it.

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?