| View previous topic :: View next topic |
| Author |
Message |
HenkN Newbie

Joined: 15 Nov 2004 Posts: 2
|
Posted: Mon Nov 15, 2004 3:39 am Post subject: Search and replace Formules |
|
|
I am trying to search and replace a part of a formule, but I am doing something wrong probably, because the program does not replace it.
I have use the formule =If(B3=0;0;B3/$AB3) alot.
The last part $AB has to become $AF.
A search and replace won't work. I already checked if the option "Formules" was selected. I am using OOo 1.1.3.
I hope someone can help me out!
Already tnx! |
|
| Back to top |
|
 |
JohnV Administrator

Joined: 07 Mar 2003 Posts: 8979 Location: Lexinton, Kentucky, USA
|
Posted: Mon Nov 15, 2004 5:03 am Post subject: |
|
|
| Try finding \AB and check the Regular Expressions box. |
|
| Back to top |
|
 |
HenkN Newbie

Joined: 15 Nov 2004 Posts: 2
|
Posted: Mon Nov 15, 2004 6:45 am Post subject: |
|
|
| Thanks! That did the trick! |
|
| Back to top |
|
 |
|