Any plugins or methods on spreadsheet?

[Danyo]

I have a spreadsheet file with over 5,000 names, some are all in capital letters and some are spelt fine.

My question is, is there a plugin or a method of making all the names have a capital letter at the beginning and normal letters after?

I dont want to edit 5,000 names, it will take me forever...

Thank you!

[Toon]

Not sure if this will help

CSS: Make it all Uppercase/Lowercase « DevHints

[Danyo]

Hmmm, isnt that CSS? That wont work in spreadsheet will it? If so how?

[Toon]

Copy the text into an blank html doc, use the converter and then paste it back into the spreadsheet

[Danyo]

Tried it, wont work...

I also have other fields which need to be changed like address etc...

There HAS to be a spreadsheet plugin for this, lots of people must have run into this problem.

[Kimran]

What program are you using?

[Danyo]

Excel

[Harry]

Try Ctrl+A then Shift+F3. It works in Word to toggle caps styles, try Excel.

EDIT: Search "caps" in Excel's help. First item.

[Danyo]

Ok thanks for your help, I've found a formula in Excel called PROPER and it makes the start uppercase and the rest lowercase.

I just need to figure out how to do it....anyone?