Thread: how do I remove the automatic break lines in text to columns?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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 With QuoteReply With Quote