If you still want to use the FIND function, qualify it thus:

txt="Mps/Stpaul, MN ".

Application.Find(",", txt, 1)
or
WorkSheetFunction.Find(",", txt, 1)


David.


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=483349