Menu Power Query Excel 2010

[planiolro]

I have recently installed Power Query for Excel 2010. In comparison with tutorials on on the internet I noticed the existence of differences.

For instance in Split Column menu there are only two options: "by delimiter" and "by number of characters"

In other tutorials for later versions of Excel (2013 or higher) in the split column menu there are the following options:

- by Delimiter
- by number of Characters
- by Position
- by Lowercase to Uppercase
- by Uppercase to Lowercase
- by Digit to Non-Digit
- by Non-Digit to Digit

Updating to higher version of Excel is not an option since the company I work has licence only for Excel 2010.
The question is whether in Excel 2010 can I have access to the updated menu of Split Column feature?

Thank yo in advance for your answer.

 

[sandy666]

afaik, Power Query for older version is not updated
like 2010 <> 2013 <> 2016 <> 2019
solution: upgrade Office version or use PowerBI Desktop
Be aware M from higher version may not work on older version