Eliminate last word in a string

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a long list of names that all contain the
word "count" at the end of the string. Example: "XYZ
Company Payment Count" I need to eliminate the "Count"
from all the rows in the column. Thanks for your help.
 
Hi
have you tried to use 'Edit - Replace'. Or is the last word different
in each row?
 
I can't Edit-Replace because each row is a different
string of words the only word that is the same is the very
last one, "Count".
 
Hi
use the following formula in a helper column:
=TRIM(SUBSTITUTE(A1,"Count",""))
and copy down for all rows

or simply use Edit - Replace. As search value enter:
' Count'
(without the apostrophes)
and leave the Replace box empty
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct Help 3
Excel 2007 Pivot Table Question 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Maximun number of hyperlinks in Excel 4
Formula for extracting text formated numbers within ( )'s as numbe 5
Counting strings of consecutive numbers in a column 1
Splitting cells 3
Count Consecutive Values 7

Back
Top