Cortana should learn excel syntax so that I don't have to
Cortana should learn excel syntax so that I don't have to. Pretty simple, for users that don't want to learn functions such as left/right, they should simply be able to say "Cortana, take the last 3digits off that column and put them in the next column" "Make me a pie chart with the colors red white and blue"
(2015-11-05 Dan [MS] - added to Formulas and Functions category)
Thanks for the post. As always, we’ll be looking at ideas in priority order according to the number of votes things have. So please keep voting for things you want to see done sooner!
John [MS XL]
Patrick O'Beirne commented
That looks like Flash Fill. Type the first couple of entries and Excel figures out what pattern to follow for the rest.
Kenneth Barber commented
In order to avoid ambiguity, you would have to be much more specific than in your examples, which would then make it slower than just doing it yourself.
For example, does "take the last 3 digits off" mean RIGHT(,3) if the last 3 characters are digits? Does it mean MOD(,1000)? Also, in your pie graph example, you would have to have your selection made by mouse before speaking, since speaking the selection would be frustrating.
If this does get implemented, Cortana should use formulas rather than hard-coded values where appropriate, as in the "take the last 3 digits off" example.