How to find part of a string in another sheet
I have a sheet with a string, say xyz, this is not always the same length.
In another sheet an have a column of numbers, which have values which are variable-length strings with values which in the case of the xyz is abcd123xyz
I need to find the row that has the xyz is the column.
Is there a way to do this?
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Help Article Resources
Check out the Formula Handbook template!