Excel 2002, problem with Text to Columns

J

jbclem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top