Thread: [Solved] Using wildcards with SEARCH
View Single Post
 
Old 10-06-2020, 03:33 PM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Using wildcards with SEARCH

Hello, I’m trying to find a formula that will extract any “-“ that is sandwiched between any two characters that are not spaces. i.e. Q-5, h-k, 9-0. I was thinking this would work to find them, =SEARCH("?-?",B2), but it does not because apparently a blank space qualifies as a character in this case. It would be helpful if the formula would work for more than one instance of the situation in any given string if the situation occurred more than once. Thank you
Reply With Quote