Hi,
I would like to make sure that two text entries are similar (but not necessarily EXACTLY the same).
The first few letters of the two entries will always be the same in my case though.
i.e. the 2 bits of data might be Higher and Highest and i want excel to return a true when i ask it if they are the same.
How can i make excel (using vba) check that these two bits of data are 'the same' (even though they arent exact)?
Thanks
AS