Share via

Text Import Wizard option not showing in Paste Options Dialog

Anonymous
2010-09-04T21:01:50+00:00

I thought choosing "Paste Special..." and choosing "Text" was supposed to show the "Use Text Import Wizard" in the Paste Options dialog.  Am I mistaken?

If it is supposed to show, does anyone have any ideas as to why it might not? If I paste the text into an text-editor like GVIM or EMACS and then into Excel, Ido see the "Use Text Import Wizard"option.  However, I thought I used to see it when pasting, say HTML, and choosing "Paste Special..." + Text. No longer...

This happened to me on Office 2007 and I just gave up and used the intermediate text-editor work-around.  I'd really prefer not to do that.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2010-09-05T11:45:11+00:00

    YES, you are mistaken. Text under Paste Special , is to only copy the text from the copied location or source.

    Text option paste's the only the text without any formatting from source. It is just plain text.

    If the above was helpful please click "Vote as helpful". If it solves your problem click "Mark As Answered". Cheers !!!!!!!!!!

    3 people found this answer helpful.
    0 comments

10 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-11-09T00:43:06+00:00

    I think I may have figured a workaround. 

    Paste the contents of a delimited string into a single cell.

    Next click on the cell that you just pasted the data into and select the "text to columns" option from the data tab. 

    This will open the same dialogue window that we are all so familiar with that allows you to import the data into separate columns.

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2012-06-04T00:35:08+00:00

    I know the issue I found a work around for my issue. Maybe it works for you too  

    I past my data normal in excel, I select data tab in the task bar and click on Text to Columns, ( on the right or the filter button ) after that the text wizard appears.

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2014-11-27T10:36:43+00:00

    This happens when excel detects html styling in your clipboard. Paste into a plain text editor (like notepad) and copy again to get rid of the html styling. Now you should see text importer option.

    10 people found this answer helpful.
    0 comments
  4. Anonymous
    2016-05-26T17:26:53+00:00

    I realize that this is an old thread, but I just wanted to mention that the same exact problem occurs in Excel 2013, too, and your workaround works perfectly there, too. I wish, Steve Bianchi, I could mark your reply (which 31 folks have found helpful) as the answer -- instead of the snide, unhelpful remark which is, inexplicably, marked as the answer.

    4 people found this answer helpful.
    0 comments