Apr 23 2021 03:07 AM
Good morning,
I'm trying to find a way to retrieve if part of text is contained in other column, and if so, then retrieving that info in my cell.
Example:
Column A: 00102MEA5411 (data to be found in column B)
Columna B: JFK20200102MEA5411
No all data have the same structure.
Therefore I'd need to find if that word in column A is contained in any cell of column B.
Many thanks
Apr 30 2021 12:27 PM