Zend certified PHP/Magento developer

Find and Replace cell reference

I remember there’s a way that you can use find and replace to do following:

=Sum(A1,B1)… to become =Sum(A1, B1:B1)…

Not replacing “B1” with “B1:B1”, but replace a single cell reference to become a range cell reference.

If anyone can please help and advise, thanks a lot in advance.