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