| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Field Character Changes
I have a row of approx 3000 names that are in all uppercase. The are in the
format of FirstName LastName. How can I set a formula to leave only the first character of the first and last name in uppercase and the rest lowercase. Such as John Doe instead of JOHN DOE. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Searching a cell for a certain character. | Excel Worksheet Functions | |||
| 15 character field truncating | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Threaded Mode
