Deleting Specific Word from Column

[W2SANC]

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! 

[W2SANC]

Apologies about this! The desired output is: 

Clay

Acorn

Bell

Anchorage

Brock

Orange

Smith

Willacy

Carter

[Ahmedx]

pls try this

[W2SANC]

This did not work for me. Any other ways to fix this error?

[Ahmedx]

this variant try

[Ahmedx]

explain why it didn't work

[Ahmedx]

pls try this

[Ahmedx]

do you need to remove the words county from the Name of column ?

[Ahmedx]

It’s not clear what you want, the result is the same as the input data

[Ritaf1983]

Hi @W2SANC 
What is the difference between the example and a desired output?
It seems the same ...