Replace text in formula
 

Hi,
Two questions:
1.
I have a formula which is in quite a few cells. I want to change a specific
text can I do this en mass, or do I have to do each on manually.
e.g.
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173="P"))/D178*100
I want to change the "P" to search for any entry in a cell in the relevant
columns.

2.
What do I replace the "P" with to be able to search for any entry in the
relveant column?

Thanks in advance

Replace text in formula
 

1. Select the column. Hit Ctrl+H. Find What: "P" Replace with "C" and hit
Replace All

2. Change your formula to a cell reference
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173=J1))/D178*100
where J1 holds the text string P


If this post helps click Yes
---------------
Jacob Skaria


"J Alcorn" wrote:

Hi,
Two questions:
1.
I have a formula which is in quite a few cells. I want to change a specific
text can I do this en mass, or do I have to do each on manually.
e.g.
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173="P"))/D178*100
I want to change the "P" to search for any entry in a cell in the relevant
columns.

2.
What do I replace the "P" with to be able to search for any entry in the
relveant column?

Thanks in advance

Replace text in formula
 

Click Edit/Replace on Excel's menu bar, put this in the "Find what" field...

="P"

and put this in the "Replace with" field...

<""

Then hit the Replace All button.

--
Rick (MVP - Excel)


"J Alcorn" wrote in message
...
Hi,
Two questions:
1.
I have a formula which is in quite a few cells. I want to change a
specific
text can I do this en mass, or do I have to do each on manually.
e.g.
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173="P"))/D178*100
I want to change the "P" to search for any entry in a cell in the relevant
columns.

2.
What do I replace the "P" with to be able to search for any entry in the
relveant column?

Thanks in advance

Replace text in formula
 

Seeing Ricks reponse I think I have misunderstood. You should be using <""
within quotes

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

1. Select the column. Hit Ctrl+H. Find What: "P" Replace with "C" and hit
Replace All

2. Change your formula to a cell reference
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173=J1))/D178*100
where J1 holds the text string P


If this post helps click Yes
---------------
Jacob Skaria


"J Alcorn" wrote:

Hi,
Two questions:
1.
I have a formula which is in quite a few cells. I want to change a specific
text can I do this en mass, or do I have to do each on manually.
e.g.
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173="P"))/D178*100
I want to change the "P" to search for any entry in a cell in the relevant
columns.

2.
What do I replace the "P" with to be able to search for any entry in the
relveant column?

Thanks in advance