ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text to Columns (https://www.excelbanter.com/excel-discussion-misc-queries/183436-text-columns.html)

F. Lawrence Kulchar

Text to Columns
 
I am using, from the Data menu, the "text to columns" feature in Excel;

I am copying data from the internet, and the text to columns wizard,
correctly, suggests 'fixed-width' in step 1.

ALL OF A SUDDEN, THE TEXT TO COLUMNS WIZARD INCORRECTLY OPTS FOR 'DELIMITED'
WIDTH IN STEP 1....THEREBY FORCING ME TO INPUT THE VERTICAL LINES FOR THE
COLUMNS.

This was a SUDDEN change from the norm, as I have been inputting data for
days into this spreadsheet.

How can I get the "text to columns" wizard to revert back to 'fixed-width'
in step 1 of the process...(yes, I can manually override the wizard, but this
(inputting the vertical lines) is time consuming)??

Thank you,

FLKulchar


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com