There are a few ways. If there is only one comma, then this is what I suggest:
strLastName = Left(strTest, InStr(strTest, ","))
strFirstName = Right(strTest, Len(strTest) - Instr(strTest, ",") + 1)
[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]