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.
Keep Up with TechRepublic