Thread: extracting data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default extracting data
no------type

25 ------people online
1 -------purchased
120 -----total on line today
1233 ----total on line year
=LEFT(A1,SEARCH(" ",A1)-1) =MID(A1,SEARCH(" ",A1)+1,255)

Regards,
Stefi

Reply With QuoteReply With Quote