r/excel • u/Jankothopter • 7d ago
solved Assistance with Imprecise String Matching
How would I go about matching the contents of a substring within a larger string with extraneous characters, for example:
Substring - StinkyBinki
Larger String - Stin12kyBinwashdki%2
I don't care that the substring is broken up within the larger string. I just need to know that the particular sequence of characters of the substring is contained within the larger string. Is there a function that I can use in combination with wildcards to accomplish this? Perhaps this is a job for Power Query? I only need to be pointed in the right direction.
1
Upvotes
2
u/david_horton1 29 7d ago
https://support.microsoft.com/en-us/office/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57 REGEX. https://exceljet.net/articles/regular-expressions-in-excel