Excel question...

[FalcomPSX]

I have a bunch of cells in excel that are filled with data such as below

THIS IS ONE CELL
THIS IS ANOTHER CELL
THIS IS YET ANOTHER CELL

all in caps, its actually a customer list, but for simplicity assume its this. Is there a simple way to convert it to look like this?

This Is One Cell
This Is Another Cell
This Is Yet Another Cell


please help!

[EXreaction]

Not that I know of...but it would be cool to find out!

I always wanted something that would do that automatically...well something I could find...I don't want to code it for myself...but...I just might code something for it...VB here I come!

[jjakobsen]

Not sure about in Excel, but you can export the spreedsheet to Word. Then select all the text and go to Format > Change Case > Sentence Case ot Title case. Then export it back into excel

[EXreaction]

Well, this is what I made...it would take more work to Make It Look Like This, but this is good for some of the stuff I use...a well...I will probably never use it, but you can try it if you want...

EDIT: all it does is converts "This" to either "THIS" or "this" depending on what button you hit...

[FalcomPSX]

well i found it. converts anything to proper caps. it's a formula, intelligently called "Proper(CellID)" works great.