If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to replace a formula string with * in the leading position?
It's convenient to use Edit -- Replace tool to change part of a formula
string with repeated characters, but strings that starting leading by the asterisk mark (*) seem to be an exception, for instance, if your want to replace a selected area with something like b7*sum(....) to b7/sum(...), you input find "*sum(...)" replace by "/sum(...)", all you can get is "/sum(...)" Maybe (*) is reserved by Excel, but are there ways to solve this problem? |
#2
|
|||
|
|||
How to replace a formula string with * in the leading position?
Try it like this:
~*sum(...) In EditReplace Excel thinks the asterisk is a wildcard. You need to tell it that the asterisk is the literal asterisk character. You do that by preceding the asterisk or any other wildcard like the question mark ? with the tilde character ~. -- Biff Microsoft Excel MVP "Seaq" wrote in message ... It's convenient to use Edit -- Replace tool to change part of a formula string with repeated characters, but strings that starting leading by the asterisk mark (*) seem to be an exception, for instance, if your want to replace a selected area with something like b7*sum(....) to b7/sum(...), you input find "*sum(...)" replace by "/sum(...)", all you can get is "/sum(...)" Maybe (*) is reserved by Excel, but are there ways to solve this problem? |
#3
|
|||
|
|||
How to replace a formula string with * in the leading position
Very useful, thanks a lot!
"T. Valko" wrote: Try it like this: ~*sum(...) In EditReplace Excel thinks the asterisk is a wildcard. You need to tell it that the asterisk is the literal asterisk character. You do that by preceding the asterisk or any other wildcard like the question mark ? with the tilde character ~. -- Biff Microsoft Excel MVP "Seaq" wrote in message ... It's convenient to use Edit -- Replace tool to change part of a formula string with repeated characters, but strings that starting leading by the asterisk mark (*) seem to be an exception, for instance, if your want to replace a selected area with something like b7*sum(....) to b7/sum(...), you input find "*sum(...)" replace by "/sum(...)", all you can get is "/sum(...)" Maybe (*) is reserved by Excel, but are there ways to solve this problem? |
#4
|
|||
|
|||
How to replace a formula string with * in the leading position
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Seaq" wrote in message ... Very useful, thanks a lot! "T. Valko" wrote: Try it like this: ~*sum(...) In EditReplace Excel thinks the asterisk is a wildcard. You need to tell it that the asterisk is the literal asterisk character. You do that by preceding the asterisk or any other wildcard like the question mark ? with the tilde character ~. -- Biff Microsoft Excel MVP "Seaq" wrote in message ... It's convenient to use Edit -- Replace tool to change part of a formula string with repeated characters, but strings that starting leading by the asterisk mark (*) seem to be an exception, for instance, if your want to replace a selected area with something like b7*sum(....) to b7/sum(...), you input find "*sum(...)" replace by "/sum(...)", all you can get is "/sum(...)" Maybe (*) is reserved by Excel, but are there ways to solve this problem? |
Thread Tools | |
Display Modes | |
|
|