Forum Discussion
Deleting Specific Word from Column
Hello PBI Community!
I have a column of different county names, some just the name, others, the name and the word county. See below for the example and desired output.
Example:
Column Name: County Name
Clay
Acorn
Bell County
Anchorage
Brock County
Orange County
Smith
Willacy
Carter County
Output Desired:
Clay
Acorn
Bell County
Anchorage
Brock County
Orange County
Smith
Willacy
Carter County
I have tried extract after deliminator, but it just deleted the entire cell contents, as county is the last word in the cells. I know replace value is an option, but with 30,000 lines with a decent % having ending in the word county, I was hoping to see if there was a less manual way of doing this.
Thanks in advance!
Hi W2SANC
What is the difference between the example and a desired output?
It seems the same ...