Change Case in Excel 2007

  flobby 20:14 10 Sep 07

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


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.

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac