| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I remove the automatic break lines in text to columns?
datatext to columnsfixed widthnext puts a column break after each
space. This just started. How do I stop it and be able to set my own column break? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I remove the automatic break lines in text to columns?
If you hover your mouse over the break line then double click that will
remove the break line. To set your own break line just point to where you want it and single click. -- Biff Microsoft Excel MVP "whoff" wrote in message ... datatext to columnsfixed widthnext puts a column break after each space. This just started. How do I stop it and be able to set my own column break? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove page break lines in normal view? | Excel Discussion (Misc queries) | |||
| how do I remove dotted page break lines from my workbook pages? | Excel Discussion (Misc queries) | |||
| Can I set an automatic page breaks to break every 40 lines? | Excel Discussion (Misc queries) | |||
| remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
| Sort columns between break lines | Excel Discussion (Misc queries) | |||
Linear Mode
