Using Combination of functions to create Proper Names from UPPER CASE Names


Home

Result in report Start procedure

In the absence of a "Proper" function the method of creating Proper Names from a Full Name Field where seperate fields First Forename and Surname are not available requires a series of 7 steps to complete the procedure. Once you are familiar with this you can combine the whole process into one nested calculation and put it in the Catalog
Warning- this method is a starting guide only and will not work with hyphenated names or unusual name constructions. Use Lookup to manually adjust these after you have created the calculation