| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change entire column in spreadsheet from upper case
imported excel spreadsheet has names in all caps. is there an easy way to
change these? for example John Smith instead of JOHN SMITH |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change entire column in spreadsheet from upper case
=PROPER(A1)
HTH -- AP "JLS" a écrit dans le message de news: ... imported excel spreadsheet has names in all caps. is there an easy way to change these? for example John Smith instead of JOHN SMITH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use spellnumber formula | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| how do I change case in an entire column of text in Excel | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Linear Mode
