Change from upper to lower case in Excel

  exdragon 21:24 05 Feb 06

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 06

This help?.click here

  exdragon 21:47 05 Feb 06

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

  diy 22:03 05 Feb 06

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

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

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 06

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 06

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

  exdragon 22:49 05 Feb 06

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

  Simsy 22:51 05 Feb 06

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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

iPad Pro 12.9 vs Surface Pro 5