Forum Discussion

W2SANC's avatar
W2SANC
Helper II
2 years ago
Solved

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 ...

9 Replies