Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

paste as text

excel is missing one important function: PASTE AS TEXT...

for various reasons pasting with excel intelligent guessing the type of data in the pasted cells do not work well, although there is no error in that (doing unexpected conversions of pasted data)...

what I need is the functionality to say to excel: paste all data as text into appropriate cells (and I will later edit it and correct and convert data)

also, convert-text-to-columns should have that functionality... yes, I am aware that I can use that functionality at the column level, but I would also like to be able to say it at once, for all the columns (for there are a lot of columns and I am not aware of where the problems with data really are before I see the data pasted...

so, let mi first put data in the cells as text and I will later handle what is to be handled...

this is a hugely missing functionality in excel, thanks :-)

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gjuro Kladaric shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    already supported  ·  Dan Battagin [MS XL] responded  · 

    This is already supported, if I understand what you’re looking for. Look for Paste Special > Values (if you copied from Excel) or Paste as Text (if you copied from another app).

    Cheers,
    Dan [MS]

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • AdminDan Battagin [MS XL] (Admin, Office.com) commented  ·   ·  Flag as inappropriate

        Thanks for the additional information Gjuro.

        I think what you're looking for is captured pretty well in this idea - it'd be great if you could vote on them:

        Maintain leading 0's: https://excel.uservoice.com/forums/304921/suggestions/10551039

        Stop Excel from changing large "numbers" (actually text values) to scientific notation) - https://excel.uservoice.com/forums/304921/suggestions/10374741

      • Gjuro Kladaric commented  ·   ·  Flag as inappropriate

        of course, THIRD column in the below report is completely unimportant, it can be any column

        I just had such a sample and had not refined that idea and corrected my report

        pardon me :-)

      • Gjuro Kladaric commented  ·   ·  Flag as inappropriate

        oh, it does not really work... try this: have a text file with three columns of comma separated values

        make the last column be all digits, some kind of personal number, and let some of them have leading zeroes

        let .csv file have TABs as column separator (so lines will be automatically broken into columns and populated in three columns)

        and when you say: PASTE AS TEXT, what will be the outcome? you will get numbers in the third column AND YOU WILL LOSE THOSE LEADING ZEROS, for PASTE AS TEXT puts its data into cells that are formatted as GENERAL, and not as TEXT

        that is true even if data do not contain column separators... you get a column of GENERALly formatted cells (with all kind of problems as excel tries to be usefull servant and guess how to use pasted data)

        so, let PASTE AS TEXT mean PASTE AS TEXT TO TEXT CELLS

        better now?

        :-)

      Feedback and Knowledge Base