Replace values where text starts with x

[JemmaD]

Hi there,

I have a text column with variations of a name which I need to replace.

I want to combine a ReplaceValue with Text.StartsWith and I can't figure it out.

The text in column [BRANCH] has variations of the word Axel such as 'Axel - UK' or 'Axel EUR' and I want it all to be renamed to the word 'Service' without having to replace values across all the variations individually. 

I could do this is with a calculated column but I don't want a new column really.

I tried the below but it's wrong!

= Table.ReplaceValue(PreviousStep,each Text.StartsWith([BRANCH], "Axel", "Service",Replacer.ReplaceText,{"BRANCH"}))

[jgeddes · Accepted solution]

Try

Table.ReplaceValue(PreviousStep,each [Branch],each if Text.StartsWith([Branch], "Axel") then "Service" else [Branch],Replacer.ReplaceText,{"Branch"})