"jackie chan" wrote:
i want to change case into proper mode for a colomn which content more than
1000 row

Assume source in A1:A1000
Put in B1: =PROPER(A1)
Copy down to B1000
Then select col B, freeze values with an "in-place":
Copy Paste special Check "Values" OK
Clean up by deleting col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---