Difference in columns

[mahaveer]

Hi,


I have two columns of address, and I need to compare with these two columns and find the difference of the word.


Example:-


1105 W Riverside Dr 1105 West Riverside Drive


I need the difference between these two columns as est rive. Do we have any functions to do so?


I have attached the file on the following link:

http://www.2shared.com/file/3HkZKzUy/Test__2_.html

 

[shrivallabha]

The patterns will be very tricky to work out. You might use VBA as using functions / formulas will be difficult.


Or you can try out text comparison freeware like WinMerge:

http://winmerge.org/

 

[mahaveer]

thank you shrivallabha


it really works gud


Thank again dear bro...


Regards

CA Mahaveer Somani