Hi,

Am Tue, 18 Feb 2014 18:06:11 +0000 schrieb reidynem:

It is returning a #N/A value. What can I do to correct please? Yours
seems to work but I couldn't view the formula on your worksheet.

you can right click and download the workbook.
I guess the error comes because you have leading and trailing spaces in
your values. Select a whole column and run TextToColumns = Fixed width
= Finish. That will delete the spaces.

Hope what I am saying makes sense but I can email you print screens if
that helps?

Screenshots are not helpful in your case. But you can post me the
workbook.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2