Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 12th 19, 07:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2017
Posts: 5
Default problem using Text to Columns (Excel 2003)

I import paragraphs of text into a spreadsheet regularly. I use Text to
Columns to fit the text into the visible part of the spreadsheet. But
occasionally I run into some text that, when pasted into the spreadsheet,
has a strange effect on the Text to Columns operation. This is what is
does:

1. whereas the default mode for file type is "delimited", this oddball text
changes that mode to "fixed width".
2. at the same time, in the Data Preview section where I usually chose and
mark a dividing line, the preview is filled with many dividing lines(10 or
more every 70 spaces, at random intervals) and it is very time consuming to
remove them one at a time.

This problem has been occurring mostly with text (paragraphs) I copy from a
Twitter account. I wonder if anyone knows of this problem and has a
workaround.



  #2   Report Post  
Old June 12th 19, 03:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,039
Default problem using Text to Columns (Excel 2003)

I import paragraphs of text into a spreadsheet regularly. I use Text to
Columns to fit the text into the visible part of the spreadsheet. But
occasionally I run into some text that, when pasted into the spreadsheet, has
a strange effect on the Text to Columns operation. This is what is does:

1. whereas the default mode for file type is "delimited", this oddball text
changes that mode to "fixed width".
2. at the same time, in the Data Preview section where I usually chose and
mark a dividing line, the preview is filled with many dividing lines(10 or
more every 70 spaces, at random intervals) and it is very time consuming to
remove them one at a time.

This problem has been occurring mostly with text (paragraphs) I copy from a
Twitter account. I wonder if anyone knows of this problem and has a
workaround.


Suggestion:
Try using a single column of reasonable width to view the paragraphs, and Wrap
Text turned on. This should render your paragraphs Exactly as rendered in
source.

*NOTE*
I always Paste online text into my text editor *before* I do anything with
it. Then I may remove any 'junk' in tow from the online HTML before I
Copy/Paste to a spreadsheet (Excel, Calc, my own).

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old June 15th 19, 02:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2019
Posts: 1
Default problem using Text to Columns (Excel 2003)

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

  #4   Report Post  
Old June 15th 19, 04:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,039
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002, problem with Text to Columns jbclem[_2_] Excel Discussion (Misc queries) 0 October 15th 12 05:40 AM
Excel 2003 get text after wraptext problem Harry[_10_] Excel Programming 3 February 23rd 10 02:26 AM
Excel 2003 How do I make a chart from a text file with columns of new excel user New Users to Excel 1 July 28th 08 09:28 PM
Excel 2003 unwanted automatic Text to Columns Hollie C[_2_] Setting up and Configuration of Excel 4 April 8th 08 10:42 PM
Wrap text problem in Excel 2003 [email protected] Excel Discussion (Misc queries) 7 January 11th 06 04:48 PM


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017