IF Text Starts With in Power Query

[Jay2022]

Hi all how do i use the Text.StartsWith in Power Query in this scenario if i had a column saying something like London Region or London Area etc but i just wanted to say if coln starts with london then....

What would be the correct formula ?

[Jay2022]

Excellent, thank you 

[Einomi · Accepted solution]

Hi,

Please try this 

if Text.StartsWith([RegionColumn], "London") then "London Group" else "Other"

If this workes, please consider accepting as a solution and give kudo 🙂