Replace doesn't carry forward to Excel

[gwaldram]

I created a Replaced Value

= Table.ReplaceValue(#"Changed Type","","A9000",Replacer.ReplaceValue,{"IDITEM"})

but upon Close & Load, the item appears as a blank.

If I filter IDITEM to only include A9000 they load perfectly.

I just got a new computer and it was working on my previous computer. I'm guessing it is a setting somewhere.

I'm lost as to what the problem is.

Thanks in advance.

Gerry

 

[AliGW]

Provide a sample workbook displaying the problem.

 

[gwaldram]

Attachments



I could not attach the file as it was too large. I downloaded screenshots. As you can see the IDITEM in power query shows A9000, but once I Close & Load they do not load into the Excel spreadsheet.

Thanks,

Gerry

 

[AliGW]

Looks like it's to do with the spaces - have you tried widening the column? Other than that, I'd need to see a sample. Cut down the workbook to produce a small subset of data that causes the problem and attach the workbook.