Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel 2002, problem with Text to Columns

I've been using Text to Columns for a few years, everytime I paste in a lot
of text that runs off the page. Usually it's easy to use, I use Fixed Width
mode and I just click/enter a break line about every 110 units. In this
mode when I start out there are no lines on the graph so it's easy to add
the ones I want to.

But recently I've found that when I go to Fixed Mode the graph is full of
break lines, at random intervals. So to use it I have to first delete each
line... which means double clicking on 30-50 lines, a real PIA.

Does anyone know how I can change this new default that adds in all these
unnecessary break lines?

John



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: Can I split PDF text into columns ? Mr. Low Excel Discussion (Misc queries) 5 November 12th 08 02:28 PM
adding up columns in excel 2002 Techno Grandma Excel Worksheet Functions 5 August 18th 07 05:00 PM
Excel 2002: How to split text into columns ? Mr. Low Excel Discussion (Misc queries) 2 March 18th 07 11:26 PM
Excel 2002 : How to segregate text into columns ? Mr. Low Excel Discussion (Misc queries) 3 December 3rd 06 04:52 PM
TEXT() function problem in Excel 2002 Boopathi Excel Programming 1 October 14th 05 11:22 PM


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

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

About Us

"It's about Microsoft Excel"