View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default problem using Text to Columns (Excel 2003)

no idea how to do it
https://independent.academia.edu/PradeepKatiyar3


Re-read my post; - it explains how to preprocess online text before pasting
into Excel *and* it explains how to prepare a worksheet to receive the text.

Excel puts each "newline" on a separate row SO..., if your target column is
wide enough to suit the paragraphs will parse to their own individual rows.

Note that Copy/Paste only accepts 256 characters per cell so you may have to
copy/paste in blocks.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion