Hi,

I have a sheet with two columns of names, entered in uppercase letters.

I need to loop through a given range of cells and change the case
permanently to normal 'name' convention (first character uppercase and
the rest lowercase) for each word in each cell.

Thanks a LOT if someone has a quick solution for this

regards

Jake