How can I change text to proper text in multiple cells.

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.

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