View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jenn jenn is offline
external usenet poster
 
Posts: 107
Default Find and Replace exclusion

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,