Share via

Power Query, Split Columns

Anonymous
2022-06-27T20:11:59+00:00

While watching a tutorial about Power Query, I saw that the software allows for splitting columns by digit to non-digit. When I opened up my Excel/PQ to practice doing so, I noticed that I only have two split column options (by delimiter; by number of characters). I have the 2019 Microsoft Office version of Excel. Can anyone tell me why I do not have the other split by options (e.g. by digit to non-digit)?

Microsoft 365 and Office | Excel | For business | 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 No comments

1 answer

Sort by: Most helpful
  1. triptotokyo-5840 36,686 Reputation points Volunteer Moderator
    2022-06-27T20:55:15+00:00

    Just tested that in Microsoft 365 where the option you want’s available.

    I can only assume that the other 5 options weren’t made available / weren’t yet available in the 2019 version.

    PS - See also here:-

    Split a column of text (Power Query) - Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010

     - where I notice that your version isn’t mentioned.

    Was this answer helpful?

    0 comments No comments