Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-06-2020, 03:33 PM
14spar15 14spar15 is offline Using wildcards with SEARCH Windows 7 64bit Using wildcards with SEARCH Office 2010 64bit
Advanced Beginner
Using wildcards with SEARCH
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using wildcards with SEARCH Search and replace, with paragraphs and wildcards alex100 Word VBA 3 05-16-2020 08:43 AM
Using wildcards with SEARCH Search and replace wildcards eduzs Word VBA 2 06-29-2019 03:01 AM
Using wildcards with SEARCH Need Search and Replace Help w Wildcards Oberstfunster Word 2 12-06-2018 09:28 AM
Wildcards used for Search and Replace ChrisRick Word 2 03-09-2017 05:01 AM
Using wildcards with SEARCH Search with wildcards imag Word 1 11-05-2014 11:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft