Only one thing left to solve: the "a" and "A" difference.

The comments on Exact, Len, Trim etc were eye openers.

What I am am surprised about however is the use of comma's instead of semicolons in most of the, otherwise right, solutions. In my version(s) of Excel that doesn't work.
Hans "Wrdwzrd"