Thread: name separation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default name separation
Hi,

text in a1

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

Second part
=TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1)))

Mike

"Help with Cell question" wrote:

how do i separate a single cell name "Doe, John" into two separate cells?
Reply With QuoteReply With Quote