cutting a piece of formula

[damrus]

How to cut a formula from cell? I mean not whole formula, but piece of formula.

For example I have formula like this:
=(B17-0,5*B21-0,5*B23)/(Model!M11*60%)
and I want automatically get a piece formula until the "/" sign (but without this sign).
So the result should be:
=(B17-0,5*B21-0,5*B23)

 

[TonyJollans]

If you edit the cell (either in place or in the formula bar), it's just text and you can select and copy any part of it you want. Am I missing something?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[damrus]

I know it
But I want doing this automatically by dragging a formula to fill in that many rows. Each cells can have different formula...

Maybe it should be as function in VBA...

 

[SkipVought]

Each cells can have different formula...

This often is a RED FLAG. Not a normal practice.

Exactly WHAT are you trying to accomplish (your cut and paste is a method toward WHAT?)


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[damrus]

In first cell I have: =(A1+B1+C2*C1)/D2+D1 -> I want: =(A1+B1+C2*C1)

In second cell I have: =(E1+B1-E2)/D2-F1+D2*C2 -> I want: =(E1+B1-E2)

In third...
In each cell can be different formula, so I cant
and this I want to achive.
The result should be a piece of given formula until the character "/" (but without the character) So I can't pulling cells down, because formulas are different. I would like to do automactically, not manually like cut and paste

So... the formula could be like this:

CUT&PASTE(formula; from beginning; until "/")

Sorry if I'm not clear.

 

[combo]

1. select the range you need to search.
2. go >Replace..,
3. in find: /*,
4. leave empty in replace,
5. search in formulas,
6. go >replace all.
This procedure searches for the first division mark in formula (as you asked). If it can be between first pair of braces, slightly modify conditions:
3. in find: )*
4. in replace: )

combo

 

[damrus]

Thanks a lot!