Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using wildcards with SEARCH Using wildcards with SEARCH
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-07-2020, 12:06 AM
Purfleet Purfleet is offline Using wildcards with SEARCH Windows 10 Using wildcards with SEARCH Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Can you add an examples worksheet so we doint have to waste time recreating the data and possibly getting it wrong?


Try =IF(AND(MID(A1,SEARCH("-",A1)-1,1)=" ",MID(A1,SEARCH("-",A1)+1,1)=" "),A1,SUBSTITUTE(A1,"-",""))
Attached Files
File Type: xlsx Using wildcards with SEARCH_Purfleet.xlsx (9.0 KB, 8 views)
Reply With Quote
 

« Previous Thread | Next Thread »


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 04:40 AM.

Contact Us - Privacy Statement - Top

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