[delete everything between]
 

Hello from Steved

I would like to replace [what ever is between the bracket] and including the
bracket
leaving nothing. It is placed in a formula hence the reason to delete the
brackets and what is between the brackets. Yes I copied the formula from
another worksheet, and the brackets and in between refers back to that
worksheet.

Thankyou for your time

ps is it possible to copy a formula from one sheet to another.

Hi,
Select your cells containing the formulas then go to Edit/Find, in the
"find what" box type and leave the "replace with" box empty, hit
"Replace All"

About copying a formula, I'm assuming you want to display the result of
a formula from a worksheet in another worksheet, if so then use Paste
Special and select "paste link"

Hope this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=473182

Hi Steved,

Some info on copying Formula.
http://www.excelforum.com/showthread...84#post1049284

Dave
Steved Wrote:
Hello from Steved

I would like to replace [what ever is between the bracket] and
including the
bracket
leaving nothing. It is placed in a formula hence the reason to delete
the
brackets and what is between the brackets. Yes I copied the formula
from
another worksheet, and the brackets and in between refers back to that
worksheet.

Thankyou for your time

ps is it possible to copy a formula from one sheet to another.


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=473182

I thankyou both.

"Steved" wrote:

Hello from Steved

I would like to replace [what ever is between the bracket] and including the
bracket
leaving nothing. It is placed in a formula hence the reason to delete the
brackets and what is between the brackets. Yes I copied the formula from
another worksheet, and the brackets and in between refers back to that
worksheet.

Thankyou for your time

ps is it possible to copy a formula from one sheet to another.