ExcelBanter - Text to columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Text to columns (https://www.excelbanter.com/excel-worksheet-functions/161312-text-columns.html)

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.

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.