View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Blass Robert Blass is offline
external usenet poster
 
Posts: 35
Default How to parse long spaced entry into multiple cells???

On Thu, 19 Mar 2009 20:58:07 -0400, "Rick Rothstein"
sayd the following:

You will need to give us just a little more information. Can any entries in
any of your fields (for example, "Brand Name") have spaces in them? You
didn't show an example, but for any of the data having commas, is there a
space next to it... or is the comma the only delineation between fields?



The data would be as follows
Each piece of data would follow with a separating SPACE until the very
end and Commas would be treated as another single SPACE to sepearate
the piece of data until end of line is reached.

"Brand type this that and that again" example
"brand,style,yes,no" would then read "brand style yes no"


If I didn't make that clear, ask again.