How do I drop a particular word

[Brad1]

Hi All,

Thanks in advance for any help!

How can I drop a particular word, whenever, found out of a given field?  I want to drop the word "Parish" for certain (for state of LA) and maybe the word "County" too.

Example:

County Name                               County Name Results

Benton County                              Benton

St Charles County                        St Charles

Arnold Parish                                Arnold

St Louis County                            St Louis

Thanks

[CharlieS · Accepted solution]

The simplest version is to use a Formula tool to replace the word with a blank with a formula like this:

Replace([County Name]," County","")

I've attached an example that show this in action along with another method that uses the Find Replace tool.

[Brad1]

Prefect, thx!