Related:

- Match cells in excel with all characters same except one
- Excel if first characters match - How-To - Excel
- Excel count specific characters in cell - How-To - Excel
- Excel VBA - Find and Expand matching cell entries ✓ - Forum - Excel
- How to match names in excel where spelling differ ✓ - Forum - Excel
- Change the highlight color of selected cells in excel 2016 - How-To - Excel

Blocked Profile

Well, for that function you get the LEFT.

as in...

=IF(LEFT(F2,5)=LEFT(G2,5),IF(F2=G2,TRUE, FALSE),FALSE)

I REALLY HOPE THIS ISNT A SCHOOL PROJECT.

So lets take a look at what happened:

First Formula:

=If(logic test, true, false)

So we then nested in the LEFT Method, that says look at the cell, and return the LEFT MOST 5 characters in the logical test of the IF. So if the left most matches, it returns a true.

Second Formula:

So in the True column of the first IF statement, we have to run what happens when it is true.

=if(f2=g2,true,false)

SO we then look at the whole value of the cell, and match it completely, nested within another if statement.

Please understand, you can use RIGHT to check the right most for trailing characters, also.

Have Fun!

//ark

-Contributor

as in...

=IF(LEFT(F2,5)=LEFT(G2,5),IF(F2=G2,TRUE, FALSE),FALSE)

I REALLY HOPE THIS ISNT A SCHOOL PROJECT.

So lets take a look at what happened:

First Formula:

=If(logic test, true, false)

So we then nested in the LEFT Method, that says look at the cell, and return the LEFT MOST 5 characters in the logical test of the IF. So if the left most matches, it returns a true.

Second Formula:

So in the True column of the first IF statement, we have to run what happens when it is true.

=if(f2=g2,true,false)

SO we then look at the whole value of the cell, and match it completely, nested within another if statement.

Please understand, you can use RIGHT to check the right most for trailing characters, also.

Have Fun!

//ark

-Contributor

A B

12345abcd 56789reft

45678defghijk 78902tery

67890sdf 12345abc

So in the above case the third value in column B partially matches the first value in col A . The first 5 digts in both the cells (A1 and B3) are same which is the first condition to be satisfied. Only if that is true should the remaining values be checked and if all the remaining characters are same or all characters except any one are same it should give me true. The problem is compounded by the fact that the length of the strings in col A are not equal. However the no of numeric characters in the string are always 5 irrespective of the total length of the string. Hope I have been able to explain my self more clearly this time. If you can provide me a formula or a macro it will be simply awesome.Also if you could guide me on how to deploy macros in excel.

A B

12345abcd 56789reft

45678defghijk 78902tery

67890sdf 12345abc

Thanks