Hello

I would like to know if can change cells data from all upper case letters (example: “CHARLES SIMON BLACKMAN”) to a “Charles Simon Blackman” globally. if so can you please explain

insert a column to the right of the column you're wanting to change. In the first cell of the new column, enter this:

=PROPER(cell) (cell = the first cell of the column to change)

Copy the formula down, and it will change the first letter of each word to upper case, and the rest to lower.

Hide the original column and you should be good to go!

__________________
Thanks!
Blanche