Removing text from the end of a string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Granger - 24 Jul 2007 16:46 GMT

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

Reply to this Message

Bob I - 24 Jul 2007 16:58 GMT

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

> I have a list of names each of which has the word "count" appended to the
> end, e.g. John Smith Count.
[quoted text clipped - 4 lines]
>
> Jeff

Reply to this Message

CLR - 24 Jul 2007 19:02 GMT

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

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

Vaya con Dios,
Chuck, CABGx3

> I have a list of names each of which has the word "count" appended to the
> end, e.g. John Smith Count.
[quoted text clipped - 4 lines]
>
> Jeff

Reply to this Message