[RESOLVED] Compare String

[gonzalex]

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

[Static]

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

something like this...

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