Thread: How to separate id and name from column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default How to separate id and name from column
Hi,

Assuming the code contains no spaces and aftger the first space starts
the name.

For the code:
=LEFT(A2,FIND(" ",A2)-1)
For the name:
=MID(A2,FIND(" ",A2)+1,LEN(A2))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote