Try this... =LEFT(H11,FIND(",",H11)-1)
(I'm not sure that I had correctly understood your problem, come back if I
was wrong)

--
KR

V.


"MABeatty" wrote:


I have a sheet that has names entered in a single cell in the Last,
First format. How can I grab just the last name? Is there a function
that allows me to return all the text up to the ","?


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=555007