Forum Discussion
Need help on creating a calculated column
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.
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 okResult
________________________
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 🙂
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.
2 Replies
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 okResult
________________________
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 🙂
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.