| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to columns
When using Text to Columns in fixed width mode, is it possible to start with
all the break lines removed by default. It is so annoying having to go through and delete the ones that Excel thinks you want each time? I am using Excel 2000 Many thanks in advance Geoff. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text to columns
Geoff
Simply no, it would be nice but not a feature. If you have the same each time why not record a macro that would do the import for you? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Geoff" wrote in message ... When using Text to Columns in fixed width mode, is it possible to start with all the break lines removed by default. It is so annoying having to go through and delete the ones that Excel thinks you want each time? I am using Excel 2000 Many thanks in advance Geoff. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
![Geoff[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
