grimley2
New Member
- Joined
- Feb 1, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
A | B | C |
Apple Pie Banana Pear Orange Tangerine | Apple Pie Apricot Pear Plum Jam | Apple Pie Pear |
Hello, I'm looking for a formula to generate cell C in this example, displaying the common lines across cells A & B.
The data is delimited with line breaks, but is comprised of multiple lines within individual cells, not down a column.
Thank you!