Power query naming columns

Hi
Can someone explain why power query alters the way column names are entered.
I have a spredsheet wthe columns named : Start_date , End_date,

but when loaded into power query i get

Please Login or Register  to view this content.

sometimes its the start that gets the hash and quotes, it can make accessing the columns difficult and I often end up just
renaming htem a , b , c etc which is not ideal.

Does anyone have an explanation and how to avoid this.

Richard.

maybe check your column name for spaces in the worksheet

I Can't really understand it, It's just typed straight into the cell, as I've said sometimes its just easier in power query to rename A , B or somethng.
I don't knowwhere the space can come form I mean if I typed into a cell " name " , but I'm just select and type name?

Very odd.

Richard

I will , I just have to recreate a small workbook without a lot of other stuff.

I've attached a copy of the file the problem occurred in with a lot of stuff removed,

There are two query folders the second contains a query 'add start date to show #. the others are the files the
where the problem actually occurred,

Richard.

here is a problem

sd.png

That sounds possible.

Richard.

Hi Sandy,

Thanks,
and that' goes to all who had a hand in this.

Richard.

You are welcome