Find and Replace exclusion

[Jenn]

I created subtotals and am summing up based on Customer Name. I now want to
Find and Replace all of the Customer Names, but leave the Customer
Name_Total. Is it possible to exclude * Total, so that I can remove all but
these?

For example:
ABC Company 150,000 4/3/09 *I want ABC Company removed here
ABC Company 450,000 4/3/09 and here
ABC Company Total 650,000 but left here.

Or is there another option other than Find and Replace to do this?

Thanks,

 

[Sheeloo]

In Search and Replace dialog box
click on Options and choose 'match entire cell contents'

 

[Gary''s Student]

Much easier to use AutoFilter on the column:

Data > Filter > AutoFilter > Custom > does not contain > Total

then clear the visible cells

 

[Francis]

Use the Replace from Edit on the Tool bar
in Find what : ABC Company
Replace with : XYZ Co
click on the Options
check Match entire cell contents
click Replace All
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

 

[Jenn]

Thanks for this, perhaps I should have mentioned that there is more than one
Customer Name, so I can't match entire cell contents. I was looking to see
if there was a symbol, like the * that meant "do not include" Total. Thanks!

 

[Jenn]

Thanks, this is the route I'll have to go. Was hoping that there was a
code/symbol that would have allowed me to basically not include a certain
word, in this case Total.

 

[Jenn]

Thanks for this, as there is more than one Customer Name, I can't just match
all contents contents. I was hoping to find that there is a symbol/code,
similar to *, that meant "do not include" Total. Thanks!

 

[Sheeloo]

How did you insert the TOTAL rows?

Looking at your post I doubt you would have done it by hand...

Did you by any chance use a formula?

If yes then you can use F5 | Special | Constants to select and delete the
company names not having a TOTAL in the cell...

Another option is to FIND and set a format for TOTAL
then search and remove the values from cells not having that format...
but that is almost the same as FILTER...

 

[Jenn]

I used Data --> Subtotals to add up the values in the various columns. I was
basically looking to not have to report the Customer Name based on the number
of rows of data. I used the filter in the meantime, so think this will be
the easiest when running the macro/add-in that I will create. Thanks for
your help!