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

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

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

"KyWilde" wrote in message ...
|I have a formula like this in a particular cell:
| =SUM(G189,K189,O189,S189,W189,AA189,AE189,AI189,AM 189)
|
| 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

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.


"KyWilde" wrote:

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

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