That works...awesome...if you get a chance can you explain this:
Function only_text(R As Range) (why R As Range is there)
and this: If IsNumeric(Mid(v, i, 1)) Then

Thanks,

-Steve


--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile: http://www.excelforum.com/member.php...o&userid=24336
View this thread: http://www.excelforum.com/showthread...hreadid=381736