Comparison of almost similar values

Good morning ,
I have two columns to compare which represent the same serial number of a device.
However, the complete number has been entered in the first column, while the last digits have been entered in the other.
Is there a way to make the comparison?

  • column 1 * column 2 *

  • 1234567890 * 67890 *

  • 1232678948 * 78498 *

  • 586318819 * 18819 *

Hi @pollyste

You want to check if column1 contains the value of column2? In that case you can use:


but fi they arrived from two different tables is hard?

Hi @pollyste

For joining similar values between tables, you may find this of use


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.