unable to read cell text data

[tehyavanna]

Hi all,

I have created a macro which looks like below:

Please Login or Register  to view this content.

As you can see, i am comparing cell values in Column A and B, if both not the same, i insert empty cell in column B. however , it seems to be working only for numbers..but not texts or strings..

its a simple macro which i use in day to day jobs..but when it comes to 700 rows of strings..i have to manually read each line and compare

how do i read string values? is the above code correct? fyi..this is my first macro code :D so do be gentle to me

[Domski]

Hi,

Are the text strings all the same case? It can help when comparing text string to make them the same case before comparing them.

If that's not it maybe you could upload a sample workbook with a some example of where it's not working.

Dom

[tehyavanna]

Hi Dom,

Thanks for the reply.

I attached the sample data for your perusal. Some are pure numbers, and some are numbers with hyphens or alphabets.

[Domski]

Your problem was all the values in column A have trailing spaces. You can fix this using the Trim function.

This code should do what you require I think:

Please Login or Register  to view this content.

Hope it helps,

Dom

[tehyavanna]

Hey Dom!

It worked wonderfully!!! Thanks!!