ExcelBanter - change text case

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - change text case (https://www.excelbanter.com/excel-worksheet-functions/98413-change-text-case.html)

jackie chan

change text case

i want to change case into proper mode for a colomn which content more than
1000 row

Max

change text case

"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
---

All times are GMT +1. The time now is 04:53 PM.