Thread
: [Solved]
Using wildcards with SEARCH
View Single Post
10-07-2020, 12:06 AM
Purfleet
Windows 10
Office 2019
Expert
Join Date: Jun 2020
Location: Essex
Posts: 345
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
Using wildcards with SEARCH_Purfleet.xlsx
(9.0 KB, 6 views)
Purfleet
View Public Profile
Find all posts by Purfleet