I have a list of names in the format 'Last, First'

I want a funtion that will return the first name only. Basically, I
want to trim off everything before the comma as well as the space after
the comma.

I don't think the RIGHT() function will work because these names are
different lenghts, as you can imagine.

Can you help?


--
Barrett9699
------------------------------------------------------------------------
Barrett9699's Profile: http://www.excelforum.com/member.php...o&userid=37573
View this thread: http://www.excelforum.com/showthread...hreadid=573581