Thread: [Solved] Using wildcards with SEARCH
View Single Post
 
Old 10-07-2020, 12:06 AM
Purfleet Purfleet is offline Windows 10 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, 6 views)
Reply With Quote