Sorry clear in my world, but not in others!:)
Yes by menu I mean food menu.
I want to be able to take the contents of two fields in a table and merge them with some additional text. So the end result is another field with the new merged data.
In Excel I can do the following;
Field A Field B Result
Chips Fries Replacement of 'Chips' with 'Fries' on menu.
(null) Fries Addition of 'Fries' on menu.
Chips (null) Deletion of 'Chips' on menu.
Can I do...