View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbclem[_2_] jbclem[_2_] is offline
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