Hello, Does anyone know how to find the common characters across multiple strings (cells). I know how to use the Right, Left, etc functions but that will not work because what is common to a group of cells may not always start or end in the same position.

Example 1

Product 1 - 100 pack
Product 1 - 25 pack
Product 1 - 15 pack

Common string = "Product 1"

Example 2

25 lb bag Candy
100 boxes of Candy
1 bag Candy

Common string = "Candy"

Thank you in advance for your help!