Eureka, I copied the whole sheet to another workbook and started over w. the
Proper function and it worked. Don't know why but don't care. Tnx. to you
all for your help.
"David Billigmeier" wrote:
> That should work exactly the way JE and Chip said... are you sure you right
> clicked on column A, highlighted "Paste Special...", and then chose "Values"?
>
> --
> Regards,
>
> David Billigmeier
>
>
>
> "Lynn in Tulsa" wrote:
>
> > That is exactly what I did. But the A column w. the names then says
> > =Proper(a1) even after the paste special values. It's like the paste
> > function isn't working at all. I've used the formula before but this time I
> > cannot make the function perform.
> >
> > "Chip Pearson" wrote:
> >
> > > What do you mean by "didn't work"? You should be able to enter
> > > =PROPER(A1) in cell B1, fill down as far as you need to go, then
> > > copy column B, and Paste Special Values back into column A. You
> > > can then delete or clear column B.
> > >
> > >
> > > --
> > > Cordially,
> > > Chip Pearson
> > > Microsoft MVP - Excel
> > > Pearson Software Consulting, LLC
> > > www.cpearson.com
> > >
> > >
> > > "Lynn in Tulsa" <[email protected]> wrote in
> > > message
> > > news:[email protected]...
> > > > I've used the suggestions here to change all lower case names
> > > > to Proper and
> > > > to no avail. Column A has the names. I put the formula in B
> > > > and then did
> > > > the copy values back to A. Didn't work. What did I do wrong?
> > >
> > >
> > >
Bookmarks