Pasting text to Excel

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

Hello,

This is a weird question, but I need some help!! When I open excel and
paste say a text table (delimited by tabs). It all comes up in the
first column. I then do a text to columns function and it converts it
to the correct columns.

Thats Great, However when doing this again it automatically does this
without my intervention!!

Can anyone tell me where I can turn this auto feature off?

Thanks....

Sam
 
Hi

File.Open
Set file type to text
In Text Impord Wizard set data type to Delimited - Next
Set Delimiters to Tab (check it) - Next (or Finish, when you don't want to
change data types in columns)
Set data types in columns, when needed
Finish

Now you can use the new workbook directly, or you copy the data from there
into another one.


Arvi Laanemets
 
Sorry! At first I send answer, and only then I did read the question :-(


Arvi Laanemets
 
Excel tries to help you by remembering the last settings you used in Data|Text
to columns.

If you hate what it assumes, you have to reset its "guessor".

Choose a cell with some data in it.
Data|text to columns
delimited
but uncheck all possible delimiters
finish up this "dummy" data|text to columns.

Now excel has forgotten so it can't "help" as much.

You could also close excel and reopen to force it to forget.

(Sometimes this guessing memory is really useful.)
 
Back
Top