On Monday, 10 March 2014 12:53:24 UTC+5:30, Claus Busch wrote:
Hi Walter,



Am Mon, 10 Mar 2014 07:16:27 +0000 schrieb Walter Briscoe:



I did so. I am surprised columns 1 and 2 of sheet 2 are literals, rather

than formulae. I also got 0 on column 3 - I guess because I had not set

1 & 2.



is it working now?

You also get 0 if the spelling in Sheet1 and Sheet2 differs because you

have leading or trailing spaces. Run TextToColumns over each column to

delete these spaces.





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Yes, Mr Claus,

You are correct. After removing the trailing/leading spaces in Col B, it works like a charm..!!!
Thanks and regards..!

-via135