Replacing Text at Beginning of String

[KelliKnitsAlot]

Good morning! I need to replace text at the beginning of a string. I cannot use the REPLACE VALUES function because I have the same text in other cells. I tried using Text.TrimStart in M query but either get an error or just "DIR". See example of data below. End result needed would be ABCD, EFG, HIJK, LMNO DIRECTORATE 2, etc....... 

Any assistance would be appreciated.

[freginier · Accepted solution]

Create custom column in Power Query

if Text.StartsWith([Column1], "DIR") then Text.AfterDelimiter([Column1]," ") else [Column1]

[KelliKnitsAlot]

Thank you!