Need help on creating a calculated column

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

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.