+ Reply to Thread
Results 1 to 2 of 2

Text To Column

  1. #1
    ASA_Joy
    Guest

    Text To Column

    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?

  2. #2
    Ken Wright
    Guest

    Re: Text To Column

    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 :-)
    ------------------------------*------------------------------*----------------


    "ASA_Joy" <ASA_Joy@discussions.microsoft.com> wrote in message
    news:51C77984-0F1C-46B0-87A3-0AA96ABDD6AB@microsoft.com...
    >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?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1