|
|
#2
12-18-2015, 07:14 AM
|
|||
|
|||
Use this formula is cell C2, and copy paste in all the cells:
=OR(LEFT(A2,SEARCH("/",A2)-1)=LEFT(B2,SEARCH("/",B2)-1),RIGHT(A2,LEN(A2)-SEARCH("/",A2))=RIGHT(B2,LEN(B2)-SEARCH("/",B2))) It would return a TRUE when there is a match and FALSE is there is not. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Heading 1 and Table & Figures style mismatch
|
ezrayst93 | Word | 5 | 07-21-2014 11:06 PM |
| Colour mismatch inserting pictures into Powerpoint 2010 | Osprey | PowerPoint | 0 | 10-25-2012 08:44 AM |
| VBA in Excel: Add a new Word Document on Template (Type Mismatch Error)) | tinfanide | Excel Programming | 1 | 03-29-2012 09:10 AM |
| [Mismatch] Help needed!!!!!!!! | rockfielder | Word | 3 | 08-25-2011 11:45 AM |
| Resolution mismatch | Adforum | PowerPoint | 5 | 05-25-2011 12:24 PM |
Windows 10 
Office 2013
Threaded Mode