odd issue with field names in Power query formulae

[masplin]

I have downloaded some date from a website as an xlsx file and for example the field name is

"EBITDA margin (%) Last avail. yr"

However if I then add a power query command the field name appears as for example

= Table.AddColumn(#"Changed Type3", "EBITDA %", each [#"EBITDA margin (%)#(lf)Last avail. yr"]/100)

with a #(lf) inserted.

In this field "Turnover th GBP Last avail. yr" it converts to "Turnover#(lf)th GBP Last avail. yr" with the #(lf) inserted in first space

Any idea why it is doing this as makes it hard to manage the code?

Thanks any advice
Mike

 

[vahju]

I believe #(lf) is a line feed character used in Excel to make the text carry over to the next line.
My suggestion is that as soon as you bring the data into Power Query you use the Clean function (right click Transform).
You might be able to use replace values if Clean does not work.

Hope that helps.

 

[peter789]

If the line feed character is in the headers you could try the following. In power query demote the headers to first row. Then transpose the data. The headers are now in the first column. Clean this column. Transpose the data. Promote the first row back to headers.

 

[masplin]

So these are hidden characters in the excel that only show up when you write the m Code. New one on me so thanks for advice