need code to compare text

[Shan]

I need to compare 2 cells and get a true or false if the are same or
not


so if A1=cat and B1=cat true should be returned

however if a1=cat b1=cater then false should be returned

I am currently using the Like operator which returns tru for both

 

[Steven M (remove wax and invalid to reply)]

I need to compare 2 cells and get a true or false if the are same or
not


so if A1=cat and B1=cat true should be returned

however if a1=cat b1=cater then false should be returned

I am currently using the Like operator which returns tru for both

Why not compare A1=B1?

Or am I missing something?


--
Steven M - [email protected]
(remove wax and invalid to reply)

bus station = where bus stops
train station = where train stops
work station = ?