The extra spaces is definitely the problem. I've checked LEN, and I
actually have 6-7 spaces in these fields instead of the 3-4 of actual
data. I guess I'm just not proficient enough with Excel to fix this,
though, because I can't get rid of the extra spaces. I've tried CLEAN
and TRIM, but neither is removing the spaces...?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=500378