Change from upper to lower case in Excel

  exdragon 21:24 05 Feb 2006

Is this possible, please? I've received a spreadsheet containing over 1000 names and addresses, all in upper case & I want to change them.


  hzhzhz 21:35 05 Feb 2006

This help?.click here

  exdragon 21:47 05 Feb 2006

Thanks, but I've got Excel 2000 and I don't think those options are available

  diy 22:03 05 Feb 2006

Try Edit, Replace a with A etc, etc.....
Not as quick as hzhzhz link.

  hzhzhz 22:07 05 Feb 2006
  hzhzhz 22:09 05 Feb 2006
  exdragon 22:36 05 Feb 2006

hzhzhz: thanks, I'll have a look tomorrow when my brain won't be hurting so much!

diy: I'd probably be safer doing it this way, but have just realised I actually want capital initials, so, for example, replacing A with a wouldn't work with a name such as Aaron. Shame but it would have been ok to do them all lower case!

  hzhzhz 22:45 05 Feb 2006

This function will change the case of a specified cell to title case (ie The first letter of each word in the cell will be capitalised).

  hzhzhz 22:48 05 Feb 2006

I think there are some excel experts on these forums so perhaps wait till tommorow.

  exdragon 22:49 05 Feb 2006

hzhzhz - got it at last! Many thanks - I'll sleep easy now!

  Simsy 22:51 05 Feb 2006

with ASAP utilities, a free add-in.

Download and "install" as per instructions.

Select cells you want to alter

On the menu bar select "ASAP Utilities">Text>StartEachWordWithUpperCase

It really is that easy!



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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

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

Black Friday 2017 : date, sites participants & bonnes affaires