I have a table and in the table I want to create a calculated field. Also in the table is a "CompanyName" field. If the user types "Anderson Smith & Johnson" I want the calculated field to display "AS&J".
Can this be done? If so, what is the expression for the calculation?