Need help on creating a calculated column

[Anonymous]

Hi,

I've column with Country names listed as "Hong Kong Geo", Japan Geo", etc. I need help on creating a new column with only country names like "Hong Kong", "Japan" etc.

Any help on this would be appreciated.

[Fowmy · Accepted solution]

@Anonymous 

You can do it in Power Query, Under Add Column Tab > Extract and choose Before Delimiter, Leave one space and type Geo in Delimiter, press ok

Result

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Icey · Accepted solution]

Hi @Anonymous ,

You can also create a calculated column like so:

Column = LEFT([Country names],LEN([Country names])-4)

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Fowmy · Accepted solution]

@Anonymous 

You can do it in Power Query, Under Add Column Tab > Extract and choose Before Delimiter, Leave one space and type Geo in Delimiter, press ok

Result

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn