| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Case for Names
I have a data dump with names. Since the users inputs their name, the case
of the name varies. I would like to clean the names up to make them look nice. For example, the names are typically one of these three: Jeff (this is good) jeff (not good) JEFF (not good) How can I clean them up so the first letter is always capital and the rest are lower case? I hope I can do this.. Thanks! -- Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I change the cap letters of student names to lower case | Excel Discussion (Misc queries) | |||
| change data of entire column from small case to upper case | Excel Worksheet Functions | |||
| How do I change the case from all caps to proper for names I have in columns E, F, G? | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Threaded Mode
