I basically have a list box that has people titles in them.
Is it possible for me to concatenate say Mrs + Ms together so my list looks like this:
I know you can use an expression as the field, but i just don't know the syntax to achieve what i am trying to
May be this:
If(Match(FieldName, 'Mrs', 'Ms'), 'Mrs/Ms', FieldName)
=if(Title='Mrs' or Title = 'Ms','Mrs/Ms',Title)
Retrieving data ...