Home |
Search |
Today's Posts |
#1
|
|||
|
|||
[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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I 'diff' [compare content between] two Excel workbooks? | Excel Discussion (Misc queries) |