Insert a helper column to the right of the column with the names.

Then use a formula like:
=proper(a1)
and drag down that column

Then select that column
edit|copy
select the original range
Edit|paste special|Values

And then delete the helper column.

bethye99 wrote:
>
> I need to change names that are all in caps to proper case in 100 cells.
> If I click each one individually, it works, but I need to be able to perfomr
> this funcion automatically on all the cells. One other post said to be sure
> calc is set to automatic and mine is. Any instruction is most appreciated.
> Thank you.

--

Dave Peterson