Finding a match from one cell to another

[Steve1977]

Need some help if possible on something which I just cannot figure out.

Column A - Column B
PART1234 - Today the sunshine is PART1234 240mm Raining - TRUE
PART1234 - Today the sunshine is PART1234S 240mm Raining - FALSE
PART789S - Today the sunshine is PART789S 240mm Raining - TRUE
PART789S - Today the sunshine is PART789 240mm Raining - FALSE

Basically I want to scan a cell and if a certain sequence of text matches like in the example above, it will return 'TRUE'

Is this even possible?

[6StringJazzer]

Starting in row 1 and fill down:

Please Login or Register  to view this content.

However, in your second example "PART1234" is found in the string in column B. If you only want to find whole words then maybe this:

Please Login or Register  to view this content.

[oeldere]

Why not split the data in differant columns (with e.g. text to column).

After that analyse the data.

[Steve1977]

Thank you - the second method works perfectly. Appreciate you taking the time to look into

[6StringJazzer]

Thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."