Need help comparing two cell values

[pltom55]

I'm having an issue when I try and compare two cell values.

For example my code looks like
if Range("B3").value = Range("B4").value then
do something
Else
do something else

So in this case
Range("B3").value = "1501-23" and Range("B4").value="1501-23 "
it looks like it would work but it doesn't since the value in B4 has an extra space at the end of the value.
I would use another function to compare/look for a match, if they both have the value "23", but this is a dynamic macro and they values are constantly changing.\
Any suggestions how i would be able to solve this, or incorporate a wildcard somehow?

Thanks

 

[Marcelo Branco]

Maybe something like

If Application.Trim(Range("B3").Value) = Application.Trim(Range("B4").Value) Then

M.