i want to change case into proper mode for a colomn which content more than 1000 row
J jackie chan Jul 10, 2006 #1 i want to change case into proper mode for a colomn which content more than 1000 row
M Max Jul 10, 2006 #2 jackie chan said: i want to change case into proper mode for a colomn which content more than 1000 row Click to expand... 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
jackie chan said: i want to change case into proper mode for a colomn which content more than 1000 row Click to expand... 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
