Removing text from the end of a string

[Jeff Granger]

I have a list of names each of which has the word "count" appended to the
end, e.g. John Smith Count.

The names are all of different lenghts.

Is there a way to remove "count" from the right hand side of the text?

Jeff

 

[Bob I]

Edit, Replace, Find what equals spaceCount, Replace with equals blank.

 

[Guest]

Another way, using a helper column.......

=LEFT(A1,LEN(A1)-6)

Vaya con Dios,
Chuck, CABGx3