Forum

Power Query - Combi...
 
Notifications
Clear all

Power Query - Combine files - Delimiter

2 Posts
2 Users
0 Reactions
158 Views
(@ajaysimha)
Posts: 1
New Member
Topic starter
 

Hi,

Do we have to update any settings to get the delimiter option in the Power query. I don't seem to get the "delimiter" drop down option when I try to combine files.  Kindly advise.

 

Cheers

Ajaydelimiter-option-not-visible.JPG

 
Posted : 25/07/2020 1:58 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Ajay,

Welcome to our forum! I'm not sure if that feature is available in all versions of Excel as an update, but I'd recommend updating your version of Excel to see if it appears. It's not something you can choose, it's controlled by Microsoft based on your version of Excel. If you don't get it with an update, then the next option is to upgrade your license to a newer version. If you're going to do this then I highly recommend getting Microsoft 365 so that you always have the latest updates included as there are many great new features coming to Excel.

Mynda

 
Posted : 25/07/2020 7:55 pm
Share: