Missing power query functions

[stigcorneer]

Hi,
I have a Excelfile with a power query model in it.
It works fine on one computer, but when I run it in on another computer there are errors.

I use excel 2016 on both computers but the one with errors crashed a couple of weeks ago and got office reinstalled just the other day.

The error seem to appear in this function:
Table.TransformColumns(#"Transponerad tabell1", {{"Column1", each Text.AfterDelimiter(_, "Column"), type text}})

When I look at the power query window the function "Text.AfterDelimiter" just isn't there on the second computer.
Is it possible that some of the M functions are missing from the computer and how do I repair it?

 

[sandy666]

maybe on the "error" computer try replicate this from the ribbon - extract - Text After Delimiter
if there is an error you should see this on the yellow bar in PQ Editor

 

[stigcorneer]

I get this error message:
"Expression.Error: The name Text.After Delimiter was not recognised. Check the spelling"

 

[sandy666]

The name Text.After Delimiter was not recognised. Check the spelling

should be: Text.AfterDelimiter no space,
like: Text.AfterDelimiter(blablabla, ",")
or post your M-code here