Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JBeaucaire[_153_] JBeaucaire[_153_] is offline
external usenet poster
  
Posts: 1
Default Formula

Assuming that string is in A2 and the name is always followed by a
comma, this formula will pull out the name:

=LEFT(A2,FIND(",",A2)-1)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62747

Reply With QuoteReply With Quote