how do i find and replace a portion of a cell's formula?

K

KyWilde

I have a formula like this in a particular cell:
=SUM(G189,K189,O189,S189,W189,AA189,AE189,AI189,AM189)

and I'd like to change all the "189" with "192".

How can I do this without deleting each one and typing it in?

Thanks,
KyWilde
 
N

Niek Otten

Copy the formula and paste it to a cell 3 rows down. Delete the "=" sign there. Copy that one and paste to the original location.
Insert the "=" sign.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a formula like this in a particular cell:
| =SUM(G189,K189,O189,S189,W189,AA189,AE189,AI189,AM189)
|
| and I'd like to change all the "189" with "192".
|
| How can I do this without deleting each one and typing it in?
|
| Thanks,
| KyWilde
 
R

RajKohli

Is there any problem using "Replace" command from Edit menu? Click Edit -
Replace - in "Find what" type 189 and "Replace with" 192. Can also use
"Option" for more advance features.
 
Top