Is there a formula or something to find similarities between 2 fields.
Example: I know in field A and B there is the below information in them.
Field A
AB
Field B
3.2 AB
I linked the two fields above the results I'm getting at the moment is:
Field A Field B
AB
I tried using the "like" formula: If Field A like "*Field B*" then Field B else "", but the result is blank.
What I would like is, if there is a similarity between fields A / B it will display field B.
I hope this explanation is clear.
Thanks in advance.
Steve.
Edited by stevdes - 14 Oct 2009 at 8:52am