"K" wrote:
.. The names were put in Excel, it is in all
upper case. I need it in Proper.
I tried to change it and I can't get it right.
I'm not sure what you tried ?
Anyway, we could try this on a spare copy
Assuming names are in col A, in A2 down
Put in say, B2: =TRIM(PROPER(A2))
Copy B2 down
If the results are okay, select col B and overwrite col A via:
Copy paste special Check "Values" OK
Then delete col B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---