In a 'helper' column put a formula like =PROPER(A1). Copy down, then copy this
column and Edit/Paste Special,Values over the original data.
On Thu, 17 Feb 2005 14:33:02 -0800, "Dave"
wrote:
I have a file with alot of columns of data. In a couple of the columns, the
words are typed with all caps. I would like the words to have only the first
letter of each word capitalized. I can not do an edit/replace because there
are many different words. Is there a formatting or edit/replace trick that I
can use to accomplish this? Any information is appreciated.
Thanks
|