1. From the Field Explorer (Crystal XI: View > Field Explorer; Crystal 8.5: Insert > Field Object), right-click on Formula Fields and select new
  2. Enter a name for the formula and click OK
  3. Enter the formula similar to the following:

    mid({CnPrProp_1_Solicitor}, instr({CnPrProp_1_Solicitor}, ",")+2) + " " + left({CnPrProp_1_Solicitor}, instr({CnPrProp_1_Solicitor}, ",")-1)

  • Click Save and Close
  • Insert the formula into the report