Here is an example which will re-format the name LastName,FirstName to FirstName LastName. This formula assumes that the field that contains the name is called {ADO.EN_US}:

if Instr({ADO.EN_US},",")>0 then (
Right({ADO.EN_US},Len({ADO.EN_US})-Instr({ADO.EN_US},","))
+ " "
+Left({ADO.EN_US},Instr({ADO.EN_US},",")-1)

)

Input: Smith,Tom

Output: Tom Smith

For the reverse:

if Instr({ADO.EN_US}," ")>0 then (
Mid({ADO.EN_US},Instr({ADO.EN_US}," ")+1)
+", "
+Left({ADO.EN_US},Instr({ADO.EN_US}," ")-1)
)


Input: Tom Smith

Output: Smith, Tom