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,

Find and Replace exclusion
 

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

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

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,

Find and Replace exclusion
 

Much easier to use AutoFilter on the column:

Data Filter AutoFilter Custom does not contain Total

then clear the visible cells
--
Gary''s Student - gsnu200843


"Jenn" wrote:

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,

Find and Replace exclusion
 

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" wrote:

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,

Find and Replace exclusion
 

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!

"Sheeloo" wrote:

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

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

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,

Find and Replace exclusion
 

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.

"Gary''s Student" wrote:

Much easier to use AutoFilter on the column:

Data Filter AutoFilter Custom does not contain Total

then clear the visible cells
--
Gary''s Student - gsnu200843


"Jenn" wrote:

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,

Find and Replace exclusion
 

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!

"Francis" wrote:

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" wrote:

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,

Find and Replace exclusion
 

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...
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

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!

"Sheeloo" wrote:

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

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

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,

Find and Replace exclusion
 

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!

"Sheeloo" wrote:

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...
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

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!

"Sheeloo" wrote:

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

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

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,