Excel Forum

Power Query - Combine files - Delimiter

Ajay Simha

New Member

Members

Forum Posts: 1

Member Since:
July 25, 2020

Offline

July 25, 2020 - 3:58 am

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

Attachments

delimiter-option-not-visible.JPG (10 KB)

Mynda Treacy

Admin

Forum Posts: 4447

Member Since:
July 16, 2010

Offline

July 25, 2020 - 9:55 am

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

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Lynnette Altomari, Jessica Stewart, Roy Lutke, Jeff Krueger, Natasha Smith

Guest(s) 12

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Sopi Yuniarti

sandra parker

LAFONSO HERNANDEZ

Hayden Hao

Angela chen

Sean Moore

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Forum Stats:

Groups: 3

Forums: 24

Topics: 6214

Posts: 27243

Member Stats:

Guest Posters: 49

Members: 31894

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen