Text to columns

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to columns 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
text to column 1
using the =page! feature to transpose a row to column 0
Split column contents (de-concantenate) 7
Text into Columns 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Text to columns 2

Back
Top