I am trying to figure the correct syntax for a consistent name concatenation. I have two fields, First Name, and Last Name. I have used the following formula to capitalize the first letter:
UPPER(LEFT({First Name}))&LOWER(MID({First Name},2,LEN({Firs...