Partial search

[petewoolven]

Morning, I'm looking for a way to match to a partial search of a description, code or size in a stock spreadsheet I have created.

I can match with an exact search across multiple worksheets and books in both upper and lower case, but am now looking for a partial search match if possible?

Many thanks

 

[hrayani]

Hi,

Is this what you want

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Partial match on search - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[petewoolven]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Partial match on search - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Hi Peter, I'm sorry, I did look but couldn't find what I was looking for, but then had another look after I posted and found that similar one.

My apologies.