Morning guys,

I have a mail merge that comes in from Excel, where one value can either be a price eg £400.00, or can be a statement, which is "TBA (£515 per day)".

Currently, the formatting on the field is "\#£,#.00" which works perfectly for currency, but if the merge text is "TBA (£515 per day)" the outcome of the mail merge just gives £515.00, which is very clever, but not what I'm after.

Does anyone know how I could get around this? I've tried various If statements within the fields, but to no avail. That text will always be the same, by the way.

Thanks in advance,

dirtychinchilla