Kevin Hanson

My feedback

  1. 1,186 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Thanks for the post Caleb. As some folks in the comments mention, you can change the format of the cell to Text before the paste. But even so, it’s clear that there’s some user pain around this experience. We hear you and we’ll evaluate how we can do a better job here. As always, we’ll spend the most time/attention on the things with the most votes, so please keep voting for things you want the most.

      Best,
      John [MS XL]

      Kevin Hanson supported this idea  · 
    • 35 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Kevin Hanson supported this idea  · 
      • 29 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          Thanks for the feedback!

          Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?

          Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.

          Kevin Hanson supported this idea  · 
        • 2 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Kevin Hanson shared this idea  · 
          • 68 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Kevin Hanson supported this idea  · 
              Kevin Hanson commented  · 

              This would be great to have as a PivotTable summary option, too.

            • 419 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

                Thanks,
                John [MS XL]

                Kevin Hanson supported this idea  · 
              • 168 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  Kevin Hanson supported this idea  · 
                • 228 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    Kevin Hanson supported this idea  · 
                  • 35 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      Thanks for the suggestion, and thanks for showing how you’re using the FORECAST as a workaround. We’ll consider this request along with all the other ideas here and prioritize it according to the votes – so please keep voting if you want to see the priority raised!

                      Best,
                      John [MS XL]

                      Kevin Hanson commented  · 

                      This is a great suggestion. I also like the comment about having an extrapolation flag. Additionally, it would be nice to have options for different types of interpolation beyond just linear interpolation (nearest neighbor, logarithmic, hyperbolic).

                      I might suggest:
                      INTERPOLATE(NewX, KnownXRange, KnownYRange, [Extrapolate=False], [Method="Linear"])
                      as a syntax, to put the "lookup value" as the first parameter.

                    Feedback and Knowledge Base