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
Ajay
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