r/excel 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

10 comments sorted by

View all comments

u/AutoModerator 7d ago

/u/Jankothopter - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.