Concatenate two fields in the same table.
I am trying to make a unique number to use in a comparison project. To do this, I need to concatenate two fields that are already in my table. Both fields are Text field types. This is what I have ...
Forum Discussion
Try just a List formula:
List("-", [Tax ID], [Tax Number])
It makes it easier to control.
May I ask why you wanted to take the last 100 characters?
List("-", [Tax ID], [Tax Number])
It makes it easier to control.
May I ask why you wanted to take the last 100 characters?