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 |
All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com