Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I basically have a list box that has people titles in them.
Mr
Master
Miss
Mrs
Ms
Is it possible for me to concatenate say Mrs + Ms together so my list looks like this:
Mr
Master
Miss
Mrs/Ms
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)