View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default LEFT function-all to left of a comma?

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

"Jennifer F" wrote:

How do I get all the characters in a text string that are to the left of a
comma?