Text String Compare

[rainmantwo]

Is there any way to compare the first 5 characters of ce;l a2 with the frist frive chararcters of c2 and then write a true of false?

 

[Joe4]

Simply use:

=Left(A2,5)=Left(C2,5)

It will return TRUE or FALSE

 

[rainmantwo]

Can I add a delete to this

if the charatcers in c2 match the ones in a2 can you delete the c2 contents?

Thanks that was quick

 

[Joe4]

Now with an Excel formula. Excel formulas cannot delete values in other cells. You would need to use VBA to do that, i.e.

If Left(Range("A2"),5)=Left(Range("C2"),5) Then Range("C2").ClearContents

 

[rainmantwo]

Thanks for the help !! But...

Thanks,

It seemes to work fine in row 2 but I need the marco to look at all the rows.. sometimes 8,000.

Thanks again

 

[Joe4]

Then you need to write a loop to loop through the range, i.e.

Dim i as Long
For i = 2 to 8000
   If Left(Cells(i,"A"),5)=Left(Cells(i,"C"),5) Then Cells(i,"C").ClearContents
Next i

Edited to fix code.

 

[rainmantwo]

loop through

sorry, new to vb I do not know how to write a loop through

 

[Joe4]

sorry, new to vb I do not know how to write a loop through

???
I wrote it for you in my previous post...

 

[BJungheim]

Then you need to write a loop to loop through the range, i.e.

Dim i as Long
For i = 2 to 8000
   If Left(Cells(i,"A"),5)=Left(Cells(i,"C"),5) Then Cells(i,"C").ClearContents
End If

You didn't close the loop:

Dim i as Long
For i = 2 to 8000
   If Left(Cells(i,"A"),5)=Left(Cells(i,"C"),5) Then Cells(i,"C").ClearContents
Next

 

[Joe4]

My apologies, you are correct BJungheim.

I meant to type in "Next i" instead of "End If". I went back and re-editing the code.

I guess that is what I get for trying to write code at 11:00 PM when I should be in bed!