Thread: I think I need an IF function....
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default I think I need an IF function....
With the entry "Doe, John" in cell A1, here is how to get everything
before the comma:
=MID(A1,1,FIND(",",A1,1)-1)

....and everything after the comma:
=TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1)))

Reply With QuoteReply With Quote