Text To Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am frequently using the text to column function. However when I do this
and then Paste new sets of data into excel it performs the text to column on
all of my data using the delimiter that I had previously set.

It does this if I do it in a different worksheet or a new excel file.
The only work around is to completely close down excel, reopen excel and
start from there.

Is there a better way to prevent the text to column function from performing
on my pasted text?
 
You can do a Data / text to Columns with no delimiters and it won't happen,
but agreed it's a pain.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
using the =page! feature to transpose a row to column 0
Split column contents (de-concantenate) 7
Convert Number to Text for Index/Match 1
In Cell Formula to mimic text to columns. 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
text to column 1
Tab delimited to comma delimited 3

Back
Top