View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen Bye[_2_] Stephen Bye[_2_] is offline
external usenet poster
 
Posts: 12
Default How to parse long spaced entry into multiple cells???

Select column A, then use the Data Text to Columns menu option and tell it
how you want the items to be separated.