View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Bialystock[_2_] Max Bialystock[_2_] is offline
external usenet poster
 
Posts: 31
Default separate two strings

A cell contains an author's name and a book title separated by a colon.



Charles Dickens : Great Expectations



I need to get "Charles Dickens" into sAuthor

and "Great Expectations" into sTitle.



In this case there is always a space before and after the colon.