View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KyWilde KyWilde is offline
external usenet poster
 
Posts: 15
Default how do i find and replace a portion of a cell's formula?

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