Thread: Seperate text and numbers in a column?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Phil Hibbs Phil Hibbs is offline
external usenet poster
  
Posts: 100
Default Seperate text and numbers in a column?
Split on the first space:

B1=LEFT(A1,SEARCH(" ",A1)-1)
C1=MID(A1,SEARCH(" ",A1)+1,999)

Phil Hibbs.
Reply With QuoteReply With Quote