[RESOLVED] Compare String

Hi,

I'm using VB in a Excel file. I have a cell that have the text "PRODANG Janeiro 2006". I want to compare that content with a string with this text "PRODANG Janeiro", how can i do it? Now to that work i'm comparing the cell to the string "PRODANG Janeiro 2006" but i want to compare it to "PRODANG Janeiro" and make the comparasion true.

thanks

say A1 has "PRODANG Janeiro" in it and B1 has "PRODANG Janeiro 2006" in it

something like this...

VB Code:

If Range("A1") = Left(Range("B1"),Len(Range("A1")) then